Skip to main content
Microsoft Idea

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2161) 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

Power BI User on 05 Jul 2020 23:24:12

RE: Conditional Formatting - Whole Table Rows

We would definitely use this feature

Andrew Trezise's profile image Profile Picture

Rajat Parihar on 05 Jul 2020 23:23:32

RE: Conditional Formatting - Whole Table Rows

Please roll out this feature as earliest as possible. TIA

Andrew Trezise's profile image Profile Picture

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

RE: Conditional Formatting - Whole Table Rows

Entire Row Conditional Formatting! Dilly Dilly!

Andrew Trezise's profile image Profile Picture

Pedro on 05 Jul 2020 23:19:14

RE: Conditional Formatting - Whole Table Rows

I agree

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.

Merged Idea (1)