cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 Actual is greater than Plan, then show it as Green else as Red.

 

I couldn't find any solution online fitting this requirement. Any help would be greatly appreciated. 

 

Thanks in advance! 

4 REPLIES 4
Highlighted
Super User IV
Super User IV

To the best of my knowledge, clustered column charts do not support conditional formatting...yet. I say yet because I believe I've read in recent blog posts from the product teams that they are working on getting more visuals to support conditional formatting.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

Thank you, Greg! 

 

I understand that it's not available in the Clustered Column chart, are you aware of any custom visuals which can fit this requirement?

Highlighted

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")

3.PNG4.PNG

 

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.

 

 

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.
Highlighted

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.

 

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors