Skip to main content
Microsoft Idea

Power BI

Under Review

Conditional Formatting - Whole Table Rows

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

Moby on 05 Jul 2020 23:37:25

RE: Conditional Formatting - Whole Table Rows

row formatting based conditional cell values, text value based conditional formatting would be super awesome!

Andrew Trezise's profile image Profile Picture

Perry on 05 Jul 2020 23:37:15

RE: Conditional Formatting - Whole Table Rows

Yes this can be accomplished simply by adding a RowColor colum and setting the value to -1 every row that you want to color and 0 every other row. Then set conditional formatting by rule for each column using the sum of the RowColor column rule is greater than -2 and less than 0 set to desired color. This works great but each and every column of the table has to have this set exactly the same. Party on!

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:42

RE: Conditional Formatting - Whole Table Rows

Based on one of the Column Value I Want to Apply for the Entire row. Very Necessary feature to handle common Scenarios

Andrew Trezise's profile image Profile Picture

John on 05 Jul 2020 23:34:54

RE: Conditional Formatting - Whole Table Rows

totally agree! very necessary to have this feature or apply conditional format to a different column using different column/measure.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:34:46

RE: Conditional Formatting - Whole Table Rows

I need this feature to highlight rows which don't have up to date data.

Andrew Trezise's profile image Profile Picture

Donovan Foster on 05 Jul 2020 23:32:31

RE: Conditional Formatting - Whole Table Rows

This feature is necessary.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:59

RE: Conditional Formatting - Whole Table Rows

Basic feature that should be available.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:30:26

RE: Conditional Formatting - Whole Table Rows

Very useful to create heatmaps in pivot tables as well. A user cohort analysis would definitely benefit from this.

Andrew Trezise's profile image Profile Picture

Kaushik Adusumilli on 05 Jul 2020 23:30:13

RE: Conditional Formatting - Whole Table Rows

We check for inconsistencies in the date entered by user and dates recorded by machine - We would like to highlight the the entire row when the difference is out of accepted limits. Please enable full row highlighting using Conditional Formatting - for tables and matrices. This will greatly help in improving our entries.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:04

RE: Conditional Formatting - Whole Table Rows

This would be a great feature.

Merged Idea (1)