Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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