Conditional formatting on clustered column chart

[TomSinAA]

Hello,

Is there a way to set up the conditional formatting on the clustered column chart to use a range of values for the formatting.  So in the example below, I would like to set ranges: 100-95%, 94%-90%, 89%-80%, <70%.  Then color each of these ranges with a different color.  I also looked at groups but that did not look like it would work.

[JoeCronk]

Based on my testing, if you have multiple metrics on the visual you can't set the conditional formatting on the columns.  The FX button that is used to apply the formatting is only visible when a single metric is used.  Hope this helps.

[Anonymous]

That is what I was seeing as well. Anyone able to find a work around?

[v-yalanwu-msft · Accepted solution]

Hi, @TomSinAA ;

Such as Dhrutivyasa-070 Said, you could set rules as follow:

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jstew0809]

This doesn't work if it is based on multiple series. Big issue with the platform.

[Dhrutivyasa-070]

Hello, 

there is no need to done Grouping in clustored column chart. 

1. After Visulize the clustered colum chart , go into to filter of chart. 

2. select column filters

3. Change the colors using the rules like Conditional Formatting.

Tell me, this logic is usefull or not.

[TomSinAA]

When I select the visual and goto filters, it does not provide an option for step 2

After Visulize the clustered colum chart , go into to filter of chart. 

2. select column filters

3. Change the colors using the rules like Conditional Formatting.

See screen shot

Am I going to the wrong spot?

[caitlinM]

Were you able to get this working @TomSinAA ? I am in the same spot

[Dhrutivyasa-070]

Click on fx  icon