Conditional Formatting on Stacked Column Chart

[ssrinath]

Hello!

I have a stacked column chart with two measures in Y-Axis, similar to this.

I was wondering if there was any way to configure conditional formatting for the column colors? 

I see the option when I have only a single measure in the Y-Axis.

Thank You!

[OwenAuger]

Hi @ssrinath 

The Power BI interface doesn't allow conditional formatting to be set when multiple measures are added to a stacked column chart. However, if you're willing to use this "hack", you could define conditional formatting for each measure by editing the appropriate visual.json file with the PBIP format:

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/PBIP-fx-hack-dynamic-expressions-f...

I just tested myself with conditional formatting defined based on a measure and it worked.

Rule/Gradient-based formatting may also be possible but I haven't tested.

[Ritaf1983]

Hi @ssrinath 

Please relate to my solution include full explanation and alternative by the link:
https://community.fabric.microsoft.com/t5/Desktop/changing-color-of-stacked-column-chart/m-p/4812114...

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