Color change of the graphs according to the result

[Cednok]

Hello teams,

I made a report in order to analyze the satisfaction of my customers by department.

here are the columns of my excel files that allow me to make the following graph

XLS File 

Now what I would like to do is change the colors of the Bar if the rate is less than 93% (that the green bars turn red)

Do you know how I can do that?

Tanks in advance for your Help.

Regards

[dax · Accepted solution]

Hi Cednok,

When you use stacked chart, you need to know, the bar is based on value or measure. If you want to change the colors of the Bar if the rate is less than 93% (that the green bars turn red), this seems will cover on actual bar result, it don't make sense. If you just want to show a target(93%), you could create a target line like below

If you only want to change bar color, you could change this in below setting

Best Regards,
Zoe Zhi

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