Forum Discussion

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

Community Champion

7 years ago

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.

sricharan_g
Frequent Visitor
7 years ago
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?
- 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
    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.