Conditional formatting of the Line and stacked chart

[KatenokKatya]

Hello,

I have this line and stacked chart below and I am struggling to implement conditional formatting. Each of the bars is an individual product, and each product has its own yield. How can I make bars red if it is below standard yields, but if it is above green? 

Every bar  is a different product , so I cannot use regular rules like "if yield is > 50" because each product has it own standard.  Thank you. Any help is appreciated! 

[Anonymous · Accepted solution]

Hi @KatenokKatya,

You can create a formula to achieve expression based on conditional formatting. They can extract and interact with current row contents to calculate.

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
You only need to check the result value and set an if statement to compare and return corresponding color codes to use on your chart.

Notice: current conditional formatting works when you did not enable the 'legends'/'column series' field on your chart or they will be auto-assigned colors by the visual itself.

Regards,

Xiaoxin Sheng