Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional formatting in cluster column chart.

Hello Everyone,

I have a clustered column chart, with 2 data set. One is target and other is value.

If the value goes above the target then the color of that bar chart must change to red, if not than green. (Refer attached screenshot).

If there any ways to achieve this in power BI?

Appreciate your support.

 

Regards,

Saad

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    AFAIK, conditional formatting feature current only works on table and matrix visual. Maybe you can refer to following link to use advanced color control to use formula to conditional your data color:

    Data Colors Advanced Controls, November 2018 release

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    AFAIK, conditional formatting feature current only works on table and matrix visual. Maybe you can refer to following link to use advanced color control to use formula to conditional your data color:

    Data Colors Advanced Controls, November 2018 release

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks i will go through that info