Forum Discussion

BBConsultancy's avatar
BBConsultancy
Icon for Helper I rankHelper I
10 months ago
Solved

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...
Need Help
  • OwenAuger's avatar
    OwenAuger
    10 months ago

    Hi BBConsultancy 

    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.

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
10 months ago

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's avatar
jaryszek
Icon for Super User rankSuper User
10 months ago

I tested it already. Unfortunately, it is not possible, Power BI UI still after implementing hack is not allowing to have conditional formatting...