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

15edc63c 64a0-418a-8b78-92bc4937edb7 on 05 Jul 2020 22:39:23

RE: Conditional Formatting throughout

This is a BASIC feature that should have been implemented a long time ago.

Tom Andrews's profile image Profile Picture

5b610c09 32fa-4118-b62c-d6b8ffa9f00e on 05 Jul 2020 22:38:42

RE: Conditional Formatting throughout

Red, Yellow, Green formatting is key when it comes to dashboard development. All Managers want to have that visual key.

Tom Andrews's profile image Profile Picture

9e498079 0f73-4e2b-bc94-ed14231f374d on 05 Jul 2020 22:36:28

RE: Conditional Formatting throughout

Must have feature, would make things a lot easier!

Tom Andrews's profile image Profile Picture

00eb054c 6eb5-4e8c-81d5-6842648c5ebf on 05 Jul 2020 22:32:36

RE: Conditional Formatting throughout

We need this badly - An opportunity to conditional format nonmeasures /additives . There is no possibility to conditional format like if then else.

Hopefully you will pay attention to this!

Tom Andrews's profile image Profile Picture

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 22:28:49

RE: Conditional Formatting throughout

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).

Not my text but I agree fully:
I think that Microsoft must spend more time on these basic, fundamentals of reporting / dashboarding. I worry that too often they spend more time chasing cool, "glitzy" functionality, at the expense of the core functionality that other products have

Tom Andrews's profile image Profile Picture

02ceb6e3 abee-e911-a812-000d3a4f1cdd on 05 Jul 2020 22:26:36

RE: Conditional Formatting throughout

There are a variety of Text based and other conditional formatting upgrade requests. Any chance you can combine those into one? My primary focus is on conditional formatting for text. So if the field returns "Yes", color it green. Thanks, Scott

Tom Andrews's profile image Profile Picture

0d24d51f b976-4121-966d-9a63f2627789 on 05 Jul 2020 22:22:40

RE: Conditional Formatting throughout

Please add true conditional formatting. A developer should be able to base the lower/upper bounds on either a field value or a dax statement. (Ex. if(x>=y,z,a)

Tom Andrews's profile image Profile Picture

5a4a8342 8a25-4090-8d00-0c4ec61b92fe on 05 Jul 2020 22:13:58

RE: Conditional Formatting throughout

The usage here is necessary. I often use the card in the upper right hand corner to show high level KPIs, which is usually a +/- variance. Green = good, red = bad.

Tom Andrews's profile image Profile Picture

98d94637 f475-4536-8fb8-a47df603ecff on 05 Jul 2020 22:08:33

RE: Conditional Formatting throughout

Need this sort of functionality ASAP!

Tom Andrews's profile image Profile Picture

95a5cfb0 858d-4461-b914-8aee40df5d62 on 05 Jul 2020 22:06:46

RE: Conditional Formatting throughout

I don't understand why this has so few votes. Perhaps there's another similar entry? Anyway, the best way to achieve this, IMHO, is to embrace web standards. Let me build my own visualization components using SVG and CSS.