Forum Discussion

KatenokKatya's avatar
KatenokKatya
New Member
4 years ago
Solved

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 m...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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