Forum Discussion
Data Color Formatting not working properly
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.
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.
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.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.
