topic Re: Data Color Formatting not working properly in Desktop

Data Color Formatting not working properly

Anonymous — Fri, 14 Jan 2022 21:27:15 GMT

I have set up conditional color formatting for a series of charts in my BI dashboard. The rules I developed are:

In the hierarchy of charts the formatting seems to work for all data points except for a random one as shown in the bar chart below:

I do not understand why that one value is not colored red instead of yellow as shown. All values below 60% should be colored red. Any help to resolve this issue would be appreciated.

Thanks!

Re: Data Color Formatting not working properly

Anonymous — Fri, 14 Jan 2022 21:40:40 GMT

HI @Anonymous ,
Try the below

Re: Data Color Formatting not working properly

Anonymous — Fri, 14 Jan 2022 21:54:28 GMT

I did make the change you suggested and there was no change. That one specific bar didn't change color. Anything other suggestions for what I should try next?

Re: Data Color Formatting not working properly

Anonymous — Sat, 15 Jan 2022 00:52:04 GMT

Hi @Anonymous

What field is the color coding based on and what is the field used to display % on chart?

They both should be the same field.

Re: Data Color Formatting not working properly

Anonymous — Mon, 17 Jan 2022 14:55:40 GMT

The field I am using for color coding is % labor efficiency. It is the same field. It is a calculated value based on other data in the reports feeding the dashboard.

Re: Data Color Formatting not working properly

V-lianl-msft — Wed, 19 Jan 2022 05:33:13 GMT

Hi @Anonymous ,

To understand the problem more deeply,it would be best to provide a pbix-file containing the sample data.

You can also try to create measure and use conditional formatting field value :

Color = Switch(true(), [value_measure] <=2.2&& [value_measure]>=0.9 ,"green", [[value_measure] <0.9&& [value_measure]>=0.6 ,"yellow", [value_measure] <0.6&& [value_measure]>=0 ,"red")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Data Color Formatting not working properly

Anonymous — Thu, 20 Jan 2022 12:59:52 GMT

I am still experiencing where one random bar is not being formatted with the correct color. I did make sure my formatting was as was suggested above. Here is a screenshot from this morning:

The circled value should be colored red and not yellow.

Re: Data Color Formatting not working properly

V-lianl-msft — Wed, 26 Jan 2022 08:07:49 GMT

Please provide a sample pbix after deleting sensitive data to let us know your scenario better.https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216