How o change the color of the 100% stacked bar graph based on percentages displayed.\

[rishabjain237]

Hi, #community

I want to change the color the bars in the 100% stacked bar graph based on the values displayed.
I have added 2 values in this bar graph, one is Achieved % and other one is Remaining %
I want the color of achieved % to be green and Remaining % to be red.
Please guide me on how to do so. 

Thanks and Regards,
Rishab Jain

[Ritaf1983 · Accepted solution]

Hi @rishabjain237 

We don't have the functionality of conditional formatting for stacked graphs.

There is an idea about this issue you can vote for it here :

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=742c5c57-f702-4568-bbd9-e77a9ada140c

as an alternative, you can consider using a bullet chart.

Take a look at the linked tutorial:

https://www.youtube.com/watch?v=oO5AiRR7XLA

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