Power BI : Conditional Formatting in Clustered Column Chart

[sahildoshi]

Hi All,

I am working on chart where I need to compare prices of different categories over time period. I need to use Clustered column chart.

X Axis - Month

Y Axis - Price

Legend - Category

I have a bechmark value with me, if price is lower than that, then bar should appear in Red color. Is there a way I can apply this conditional formatting in Clustered Column chart? The moment I add anything in Legends section, the "fx" part under Data Colors is not visible.
@amitchandak @Greg_Deckler 

[speedramps · Accepted solution]

Hi sahildoshi

You can not apply conditional formatting to a Cluster Column Chart because the Legend colour is static. ☹️☹️☹️

Please consider using a Line and Cluster Column Chart with:-

X Axis - Month

Column Y Axis - Price

Line y-axis = Benchmark

Legend - Category

It does not use conditional formating but is an excellent visual if you just have a few categories.

The graph could get very messy if you hace lots of categories

Please click thumbs up and accept as solution. Thanks 😀