Conditional formatting in cluster column chart.

[Anonymous]

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 · Accepted solution]

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]

Thanks i will go through that info