Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Solved! Go to 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.
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.