Forum Discussion
Conditional formatting of the Line and stacked chart
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!
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
1 Reply
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