Change the color of a "Line and Stacked Column Chart" bar section dynamically depending on two value

[Anonymous]

Hi,

My need is simple.

In the bar below you may see I have 4 values. I would like that, when the value of the Orange area (currently at 1,6K) is lower than the yellow dot (currently at 1,5K), then the color Orange turns to blue.

Data colors only allow me to manage a single color but no way to put in a formula (If Higher than then show Orange, else show blue).

Thanks in advance for your support!

Best Regards,

[v-piga-msft · Accepted solution]

Hi @Anonymous,

By my tests and research, I'm afraid that we cannot achieve your requirement for this kind of visual in Power BI currently.

You could vote this similar idea or submit your new idea in Power BI ideas Forum and add your comments there to improve Power BI and make this feature coming sooner.

Best  Regards,

Cherry

[Anonymous]

Thanks for taking the time to test, I figured as much after seing that I could only turn on the color conditions by having only one column on the chart.

I upvoted the idea!

Best Regards,