Skip to main content
Microsoft Idea

Power BI

Completed

conditional formatting in tables

Vote (892) Share
marcelo's profile image

marcelo on 21 Aug 2015 09:07:01

It was implemented in charts but not in tables or matrixes.

Administrator on 31 May 2016 23:23:27

We released conditional formatting in tables with our May release of Power BI Desktop. Give it a try and let us know what you think. You can learn more about how to use it in our latest blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/.

Comments (166)
marcelo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:29:33

RE: conditional formatting in tables

We desperately need the ability to add ranges to the formatting. Example 1-99 Green, 100-199, Blue 200-299 Gold - 300 + Red

In Excel we can go well beyond 3 levels that the current conditional formatting supports. We need at least 5 levels!

marcelo's profile image Profile Picture

Diogo Maul on 05 Jul 2020 22:29:00

RE: conditional formatting in tables

Conditional formatting for Matrix is really needed!

marcelo's profile image Profile Picture

Göran Flink Joles on 05 Jul 2020 22:28:30

RE: conditional formatting in tables

Agree with previous. Add to Matrix. I also miss absolute values like if above 0 green, else red etc.

marcelo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:28:23

RE: conditional formatting in tables

Urgent to have conditional formatting and sorting in matrixes and not only tables. You have any walk around?

marcelo's profile image Profile Picture

Aimee Aimee on 05 Jul 2020 22:28:01

RE: conditional formatting in tables

awesome. :-) It looks like conditional formatting can't be applied to date fields. Is there a way around this? Or will this be added at some point?

marcelo's profile image Profile Picture

Nicolas on 05 Jul 2020 22:26:54

RE: conditional formatting in tables

look like conditionnal fomatting cannot apply also in matrix and to the whole row, not only the cell

marcelo's profile image Profile Picture

Mike Zai on 05 Jul 2020 22:26:44

RE: conditional formatting in tables

Looks like conditional formatting only works on Measures. Would be nice if would work on normal fields too

marcelo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:26:31

RE: conditional formatting in tables

This seems like a partial completion. We would like to be able to have more flexibility with conditional formatting. ie, if a value in one column is greater than a value in a different column in the same row, highlight it Green. Basically, anything we can do with conditional formatting in Excel would be great to have in Power BI.

marcelo's profile image Profile Picture

Gerhard on 05 Jul 2020 22:25:55

RE: conditional formatting in tables

Is it possible to do Conditional Formatting on a Time-data type?

marcelo's profile image Profile Picture

Chris Turnbull on 05 Jul 2020 22:25:17

RE: conditional formatting in tables

Is there another thread to Vote Up Conditional Formatting on a Matrix and also I would want Conditional Formatting that I could base the Current Column or Measure On.