Forum Discussion

BBConsultancy's avatar
BBConsultancy
Helper 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.

jaryszek's avatar
jaryszek
Super User
9 months ago

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

OwenAuger's avatar
OwenAuger
Super User
9 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
    Super User
    9 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...