Forum Discussion
BBConsultancy
10 months agoHelper I
Conditional formatting on stacked column chart
Hi All, I want to create a 100% stacked bar chart that shows the progress per employee on target. I want the 'achieved' part of the bar to be colored, and the 'to-go' part in light gray. Howe...
- 10 months ago
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.
OwenAuger
9 months agoSuper User
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
jaryszek
9 months agoSuper User
I tested it already. Unfortunately, it is not possible, Power BI UI still after implementing hack is not allowing to have conditional formatting...