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

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

Andrew Trezise's profile image Profile Picture

Markus Mantere on 05 Jul 2020 23:05:22

RE: Conditional Formatting - Whole Table Rows

Much-needed feature!

Andrew Trezise's profile image Profile Picture

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

RE: Conditional Formatting - Whole Table Rows

I'm surprised why they haven't implement this straight forward concept. Also, it will be nice if they allow to do conditional formatting on a field based on another field.

Andrew Trezise's profile image Profile Picture

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

RE: Conditional Formatting - Whole Table Rows

Yes, fairly simple concept but would be very useful!

Merged Idea (1)