Skip to main content

Power BI

Needs Votes

Conditional Formatting throughout

Vote (737) Share
Tom Andrews's profile image

Tom Andrews on 02 Sep 2015 16:45:54

It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.

Comments (50)
Tom Andrews's profile image Profile Picture

0ccea279 4113-4f0b-9002-1aab84c0c05d on 05 Jul 2020 23:47:21

RE: Conditional Formatting throughout

Really need this for dates. Greater than or less than Today () specifically...

Tom Andrews's profile image Profile Picture

92e6c774 a756-426d-baf8-73c445a931fc on 05 Jul 2020 23:47:03

RE: Conditional Formatting throughout

This is a must for dates. Particularly relatively (i.e. within the last month)

Tom Andrews's profile image Profile Picture

204dc718 a5ba-4517-9bdf-ae147224816d on 05 Jul 2020 23:37:24

RE: Conditional Formatting throughout

Conditional Formatting is vital across all visuals please.

Tom Andrews's profile image Profile Picture

6ca9101f 8bd3-4b3c-af7e-393f33a73226 on 05 Jul 2020 23:36:18

RE: Conditional Formatting throughout

Would be great to add same conditional formatting capabilities as in SSRS

Tom Andrews's profile image Profile Picture

a6122224 000d-43ab-a66d-709954580152 on 05 Jul 2020 23:32:54

RE: Conditional Formatting throughout

Conditional formatting desperately needs to be updated. I can't believe I can do so many powerful things with this product, but easily coloring text red if the date is older than X years (for example) isn't one of them. It is extremely frustrating.

Tom Andrews's profile image Profile Picture

46dbd719 d674-48a7-b0a5-d349659b220f on 05 Jul 2020 23:32:24

RE: Conditional Formatting throughout

Additionally conditional formatting across rows instead of columns needs to be incorporated.

Tom Andrews's profile image Profile Picture

9420e320 5c31-410b-80fe-a532017f865e on 05 Jul 2020 23:31:41

RE: Conditional Formatting throughout

This is a must. The data bars in matrix/tables need more color options (such as based on defined value ranges) 0-6 RED, 7-8 AMBER, >9 GREEN

Tom Andrews's profile image Profile Picture

3f2d4e25 89cf-4ced-a107-4e471a8f8fbf on 05 Jul 2020 23:31:01

RE: Conditional Formatting throughout

I desperately need to be able to conditionally format the segments of a pie chart

Tom Andrews's profile image Profile Picture

9420e320 5c31-410b-80fe-a532017f865e on 05 Jul 2020 23:29:55

RE: Conditional Formatting throughout

Conditional color formatting on PIE/Donut charts would be extremely beneficial. Color banding depending on fill value. eg,
>80% = Green
>60% = Yellow

Tom Andrews's profile image Profile Picture

3ec7b0cb 578d-48d2-bfd1-3f61dd958022 on 05 Jul 2020 23:29:36

RE: Conditional Formatting throughout

Adding conditional formatting to the background of a report would be extremely beneficial as well. We are attempting to create a dashboard that is displayed on SharePoint Online where the 'heat' boxes would have made the live dash much more dynamic.