Forum Discussion

Advocate I

11 months ago

Solved

Conditional Formatting on Stacked Column Chart

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? ...

Need Help

OwenAuger
11 months ago
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-for-properties-everywhere/ba-p/4592751

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.

OwenAuger

Super User

11 months ago

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-for-properties-everywhere/ba-p/4592751

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.