Skip to main content

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2205) 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 (142)
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.

Andrew Trezise's profile image Profile Picture

Shaishav Merchant on 06 Jul 2020 00:14:30

RE: Conditional Formatting - Whole Table Rows

Is there any update on this?

Andrew Trezise's profile image Profile Picture

Dmitriy Mezencev on 06 Jul 2020 00:11:50

RE: Conditional Formatting - Whole Table Rows

Do want

Andrew Trezise's profile image Profile Picture

Steph Coffey on 06 Jul 2020 00:11:33

RE: Conditional Formatting - Whole Table Rows

Basic functionality for daily business. Please develop!

Andrew Trezise's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:22

RE: Conditional Formatting - Whole Table Rows

it will be perfect !!!!

Merged Idea (1)