Skip to main content
Microsoft Idea

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2147) 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

Wendy Jones on 10 Aug 2021 01:47:20

RE: Conditional Formatting - Whole Table Rows

Or even if we could copy it and apply it to each column... anything is better than having to screen shot it and apply it one by one!!

Andrew Trezise's profile image Profile Picture

Robert Gregson on 23 Jul 2021 10:50:53

RE: Conditional Formatting - Whole Table Rows

Come on Microsoft, make our day! :-) This is a fairly basic reporting requirement which was requested four years ago. There are millions of people using Power BI around the world.. keep us happy! :-)

Andrew Trezise's profile image Profile Picture

Diego Vianna on 21 Jul 2021 14:27:56

RE: Conditional Formatting - Whole Table Rows

Seems a pretty basic functions, I would like to see it working.

Andrew Trezise's profile image Profile Picture

Antony Curnow on 06 Jun 2021 23:50:30

RE: Conditional Formatting - Whole Table Rows

Yeah this is pretty basic visual function that needs to be introduced

Andrew Trezise's profile image Profile Picture

Vladimir Kocic on 06 Apr 2021 17:51:57

RE: Conditional Formatting - Whole Table Rows

Seriously?? After 5 years and 1.200 paying customers the best you an do it put a sticker that says "needs more votes"?

Andrew Trezise's profile image Profile Picture

Buddhi Gupta on 10 Dec 2020 17:25:08

RE: Conditional Formatting - Whole Table Rows

We need to have a row conditionally highlighting based on Dimension in Matrix Visual. It is possible in Cognos. Please make this feature available soon so we can migrate such functionalities.

Andrew Trezise's profile image Profile Picture

Power BI User on 29 Sep 2020 20:35:25

RE: Conditional Formatting - Whole Table Rows

Please add this opportunity!!!
In my case I need to show People salaries increase within a year, and without this feature I'm not able to show a particular month where the increase has been taken place.

Andrew Trezise's profile image Profile Picture

Thet Nwe Soe on 21 Sep 2020 04:34:25

RE: Conditional Formatting - Whole Table Rows

OMG PLEASE

Andrew Trezise's profile image Profile Picture

Katie McLoughlin on 14 Sep 2020 11:03:43

RE: Conditional Formatting - Whole Table Rows

Yes please!! We often have many fields and manually applying rules to each of them is not viable, especially when adding multiple rules. Something like the formula-based conditional formatting in Excel would be amazing.

Andrew Trezise's profile image Profile Picture

Tony Alvarez on 14 Aug 2020 15:33:55

RE: Conditional Formatting - Whole Table Rows

My particular use case would allow row level conditional filtering based on a measure.

Merged Idea (1)