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

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.

Andrew Trezise's profile image Profile Picture

Richard Leo on 12 Aug 2020 00:25:51

RE: Conditional Formatting - Whole Table Rows

Please!!

Andrew Trezise's profile image Profile Picture

Twan van de Ven on 17 Jul 2020 08:21:55

RE: Conditional Formatting - Whole Table Rows

Interesting how a post of 2017 is still new? And there seems to be quite a lot of interest in.
Is this something that's going to picked up bij MS? Would be nice to know instead of leaving it at a "New" status.

Andrew Trezise's profile image Profile Picture

Lo on 06 Jul 2020 00:16:05

RE: Conditional Formatting - Whole Table Rows

Any update on this?
Thank you,

LM

Andrew Trezise's profile image Profile Picture

Don-Work MacLeod on 06 Jul 2020 00:15:19

RE: Conditional Formatting - Whole Table Rows

This is possible, although a pain. If you go into the conditional formatting for your table, you can set each column to look at a different column using the Based on Field options. As a simple example, I have a table with a Failure column (0=Fail, 1=Pass), I want to highlight rows that fail. I needed to conditionally format each column with a rule based on Failure is 0, then the whole row highlights.

Merged Idea (1)