Skip to main content

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

0d3ecfde 41c1-48aa-8922-f394ddf2c511 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

f9d297a8 e32b-49f0-b02a-a2943dbec5c5 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

0f22fcb7 a761-4cdd-9d23-e4e54346ab23 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

a5823746 bdd5-4aea-a790-d84babc57221 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

c19d6eaf 9ff3-4929-9d0f-d753fffe7b27 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

1d179270 57a9-4738-816c-28c15ffe064f 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

97042987 b8d7-40ba-a3ed-e2b06c409daa 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

8587bbee 262b-46f9-92f6-899378c71acf 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

faab29f7 8e75-47b9-b06b-fd165fbdc420 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

833daf76 f029-4f52-9783-dd5983d9f09a 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.