Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2147)

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)

Richard Leo on 12 Aug 2020 00:25:51

RE: Conditional Formatting - Whole Table Rows

Please!!

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.

Lo on 06 Jul 2020 00:16:05

RE: Conditional Formatting - Whole Table Rows

Any update on this?
Thank you,

LM

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.