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.

BBConsultancy's avatar
BBConsultancy
Helper I
10 months ago

Hi, thanks for your reply. When you use just one measure and put status in the legend, you still don't have the option to apply conditional formatting. 

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