Skip to main content
Microsoft Idea

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2160) 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 (140)
Andrew Trezise's profile image Profile Picture

Sean Cupolo on 05 Jul 2020 23:12:32

RE: Conditional Formatting - Whole Table Rows

Conditional formatting should work like in Excel where the user can designate a measure that is used as the condition for any column in the table / matrix. There could be a toggle to apply to entire row or specific columns

Andrew Trezise's profile image Profile Picture

Maarten on 05 Jul 2020 23:12:30

RE: Conditional Formatting - Whole Table Rows

How is this not a standard functionality?

Andrew Trezise's profile image Profile Picture

Pavel Power BI User on 05 Jul 2020 23:11:08

RE: Conditional Formatting - Whole Table Rows

Surprises me that such a basic and obviously useful function is not implemented.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:33

RE: Conditional Formatting - Whole Table Rows

Would be useful, but would need to be able to format based on information not in the table, i.e. I've got a monthly data table with a row for each day, and I'd like to highlight rows where we're not in work, which is a related column on my calendar table

Andrew Trezise's profile image Profile Picture

Markus Mantere on 05 Jul 2020 23:05:22

RE: Conditional Formatting - Whole Table Rows

Much-needed feature!

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:04:57

RE: Conditional Formatting - Whole Table Rows

I'm surprised why they haven't implement this straight forward concept. Also, it will be nice if they allow to do conditional formatting on a field based on another field.

Andrew Trezise's profile image Profile Picture

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

RE: Conditional Formatting - Whole Table Rows

Yes, fairly simple concept but would be very useful!

Andrew Trezise's profile image Profile Picture

Michael Svien on 05 Jul 2020 23:03:31

RE: Conditional Formatting - Whole Table Rows

I'd like to echo Tanmay's statement. I want to create a conditional format based upon a measure, and apply the format to the entire row while hiding the measure.

For example, I created a report which has various bits of info regarding various customer environments, including the last date we processed data for that customer. I created an Age measure to compare the last processing date to today's date. I want to color the entire row based upon that age measure, without actually displaying the age.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:01:10

RE: Conditional Formatting - Whole Table Rows

This is absolutely critical as I also have a need to show a row of date driven tasks that are overdue.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 22:59:26

RE: Conditional Formatting - Whole Table Rows

good idea, i'm all for that

Merged Idea (1)