Power BI

Needs Votes

Conditional Formatting - Whole Table Rows

Vote (951)

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 (92)

Comments (92)

39ca5a97 79f6-ea11-a815-000d3a9b112e 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.

b5b66cdd 42de-ea11-a813-000d3a8faea9 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.

14e595e5 31dc-ea11-a813-000d3a8faea9 on 12 Aug 2020 00:25:51

RE: Conditional Formatting - Whole Table Rows

Please!!

77ededf3 05c8-ea11-a812-000d3a9b112e 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.

b8a9d225 f094-4aab-9d72-b105691e9ea7 on 06 Jul 2020 00:16:05

RE: Conditional Formatting - Whole Table Rows

Any update on this?
Thank you,

LM

bdf9699d 7c23-4368-a467-b6b827b9e5d8 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.