Skip to main content

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2213) 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 (143)
Andrew Trezise's profile image Profile Picture

Sally Risinger on 05 Jul 2023 18:54:59

RE: Conditional Formatting - Whole Table Rows

I really need this, too! I have several matrices that only need a couple of rows to be highlighted by being bolded or having a background color. Please incorporate this user request in the next release. thank you!

Andrew Trezise's profile image Profile Picture

Shannon Hugetz on 05 Jul 2023 18:53:52

RE: Conditional Formatting - Whole Table Rows

Agreed that this would be extremely helpful and current method is a pain.

Andrew Trezise's profile image Profile Picture

Marg Evans on 28 Jun 2023 03:44:50

RE: Conditional Formatting - Whole Table Rows

I really need this. It's painful setting the conditional formatting on every field in a table! I'm old, my hands are old - please save me from destroyed finger joints caused by too many clicks.

Andrew Trezise's profile image Profile Picture

Omar Alhammadi on 21 Jun 2023 06:46:37

RE: Conditional Formatting - Whole Table Rows

Other competing solutions have this functionality. It's surprising that PowerBI doesn't.

Andrew Trezise's profile image Profile Picture

Angelo Angiolella on 09 Feb 2023 13:57:24

RE: Conditional Formatting - Whole Table Rows

Hello Microsoft.List based reports could really use this feature.My current ask is to highlight the first row of each change of group key.Tried to fake by converting the table to a matrix, but performance suffers.This enhancement request is 3 years old?Thanks

Andrew Trezise's profile image Profile Picture

Bryan Ward on 30 Nov 2022 16:26:16

RE: Conditional Formatting - Whole Table Rows

Never needed this feature in my PBI build, however today I was asked to include it. Straight forward I said yes, I can do that, given its a straightforward feature. A bit suprised that PBI doesn't support this already!

Andrew Trezise's profile image Profile Picture

Zeid Ameli on 11 Nov 2022 16:26:21

RE: Conditional Formatting - Whole Table Rows

we have almost 1800 votes and @microsoft still didn't listen....

Andrew Trezise's profile image Profile Picture

Glenn Needham on 12 Oct 2022 04:33:01

RE: Conditional Formatting - Whole Table Rows

To build workarounds for not having this functionality takes hours. How many votes do you need before adding the feature?

Andrew Trezise's profile image Profile Picture

Luke Garton on 12 Oct 2022 04:27:36

RE: Conditional Formatting - Whole Table Rows

The Year 2022 - and this functionality still doesnt exist?

Andrew Trezise's profile image Profile Picture

ADM Tim Webber on 15 Sep 2022 04:01:51

RE: Conditional Formatting - Whole Table Rows

Power BI is almost 12 years old and you cannot format a row of a table based on values in that table? Wow.

Merged Idea (1)