Forum Discussion
Conditional formatting on stacked column chart
The Power BI Desktop interface won't allow conditional formatting on any core stacked bar/column visuals when multiple measures or a legend field are included (as you've observed).
There is a "hack" which I've used in the past described in this post that involves editing the
visual.jsonfile within the PBIP format. I have tested this myself previously and it appears to work as expected, but it's not "officially" supported.
The Power BI Desktop interface won't allow conditional formatting on any core stacked bar/column visuals when multiple measures or a legend field are included (as you've observed).
There is a "hack" which I've used in the past described in this post that involves editing the visual.json file within the PBIP format. I have tested this myself previously and it appears to work as expected, but it's not "officially" supported.
Hello Owen,
did you manage to use a measure for bar charts in stacked bar chart with legend?
How did you do this? It would be exteremely helpful.
Best,
Jacek
Hi jaryszek
Actually I'm not 100% sure I have a working example for the legend version.
I will have to test again when I have a chance and let you know
I tested it already. Unfortunately, it is not possible, Power BI UI still after implementing hack is not allowing to have conditional formatting...