Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sahildoshi
Helper I
Helper I

Power BI : Conditional Formatting in Clustered Column Chart

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 

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

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 😀 

 

 

speedramps_0-1652641194032.png

 

 

 

 

View solution in original post

1 REPLY 1
speedramps
Super User
Super User

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 😀 

 

 

speedramps_0-1652641194032.png

 

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors