Skip to main content

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2229) Share
Andrew Trezise's profile image

Andrew Trezise on 14 Feb 2017 19:58:04

It would be great to be able to format full rows and not just specific columns in tables.

For example - I have a list of date driven tasks and would like to highlight the entire row where the task is overdue.

Comments (146)
Andrew Trezise's profile image Profile Picture

Andrew Chapman on 05 Jul 2020 23:46:02

RE: Conditional Formatting - Whole Table Rows

'+1 for this. Would definitely be handy.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:45:08

RE: Conditional Formatting - Whole Table Rows

I too would enjoy the formatting of a complete row rather than the column by column solution. It would make my 2019! Don't you want me to be happy?

Andrew Trezise's profile image Profile Picture

Joan on 05 Jul 2020 23:41:50

RE: Conditional Formatting - Whole Table Rows

This would be very helpful!

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:11

RE: Conditional Formatting - Whole Table Rows

Please add all the formatting options in PBI including conditional formatting entire row based on a single value or set of values

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:37:55

RE: Conditional Formatting - Whole Table Rows

This feature need.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:37:31

RE: Conditional Formatting - Whole Table Rows

I need this too.

Andrew Trezise's profile image Profile Picture

Moby on 05 Jul 2020 23:37:25

RE: Conditional Formatting - Whole Table Rows

row formatting based conditional cell values, text value based conditional formatting would be super awesome!

Andrew Trezise's profile image Profile Picture

Perry on 05 Jul 2020 23:37:15

RE: Conditional Formatting - Whole Table Rows

Yes this can be accomplished simply by adding a RowColor colum and setting the value to -1 every row that you want to color and 0 every other row. Then set conditional formatting by rule for each column using the sum of the RowColor column rule is greater than -2 and less than 0 set to desired color. This works great but each and every column of the table has to have this set exactly the same. Party on!

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:42

RE: Conditional Formatting - Whole Table Rows

Based on one of the Column Value I Want to Apply for the Entire row. Very Necessary feature to handle common Scenarios

Andrew Trezise's profile image Profile Picture

John on 05 Jul 2020 23:34:54

RE: Conditional Formatting - Whole Table Rows

totally agree! very necessary to have this feature or apply conditional format to a different column using different column/measure.

Merged Idea (1)