Forum Discussion

sricharan_g's avatar
sricharan_g
Frequent Visitor
7 years ago

Conditional formatting in Clustered column chart

Hi Everyone,   I have used a clustered column chart with 2 columns - Actual, Plan. Now, I want to apply conditional formatting as set the color of the Actual bar based on the value of Plan. If Actu...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi sricharan_g ,

For a workaround, you can try the following method in the table or matrix.

 

I created a measure to compare the difference between Actual and Plan.

Measure = IF(MAX('Table'[Actual]) < MAX('Table'[Plan]),"Red","Green")

 

The document is about conditional formatting in tables that you can reference. 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi sricharan_g ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.