Skip to main content

Power BI

Under Review

Conditional Formatting - Whole Table Rows

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

Power BI User on 05 Jul 2020 23:18:33

RE: Conditional Formatting - Whole Table Rows

Highlighting a full row would be very useful for readability. Please add!

Andrew Trezise's profile image Profile Picture

Eddie Yasi on 05 Jul 2020 23:16:55

RE: Conditional Formatting - Whole Table Rows

We get requests to highlight rows on tables just as often as requests to highlight individual cells. This is an important feature for us too! Being able to base that highlighting decision on more than one column's value in the row would be necessary as a part of this too.

Andrew Trezise's profile image Profile Picture

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

RE: Conditional Formatting - Whole Table Rows

Yes, this is another basic feature that is keeping us from fully migrating.

Andrew Trezise's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:15:27

RE: Conditional Formatting - Whole Table Rows

This is a much needed feature if MSFT wants to play the lead in the BI space!
I face huge difficulty in migrating BOBJ reports to Power BI and hence we are double thinking about Power BI.

Andrew Trezise's profile image Profile Picture

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

RE: Conditional Formatting - Whole Table Rows

This is definitely a feature that should be included in Power BI. I am migrating our call stats system from a crude Excel/VBA solution (fetching data from SQL) to Power BI and the only thing I'm stuck on is formatting the top/bottom 3 rows red/green respectively.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:41

RE: Conditional Formatting - Whole Table Rows

Complete row format option should be available.

Andrew Trezise's profile image Profile Picture

Sean Cupolo on 05 Jul 2020 23:12:32

RE: Conditional Formatting - Whole Table Rows

Conditional formatting should work like in Excel where the user can designate a measure that is used as the condition for any column in the table / matrix. There could be a toggle to apply to entire row or specific columns

Andrew Trezise's profile image Profile Picture

Maarten on 05 Jul 2020 23:12:30

RE: Conditional Formatting - Whole Table Rows

How is this not a standard functionality?

Andrew Trezise's profile image Profile Picture

Pavel Power BI User on 05 Jul 2020 23:11:08

RE: Conditional Formatting - Whole Table Rows

Surprises me that such a basic and obviously useful function is not implemented.

Andrew Trezise's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:33

RE: Conditional Formatting - Whole Table Rows

Would be useful, but would need to be able to format based on information not in the table, i.e. I've got a monthly data table with a row for each day, and I'd like to highlight rows where we're not in work, which is a related column on my calendar table

Merged Idea (1)