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

View all the Fabric Data Days sessions on demand. View schedule

Reply
yaronklein
Helper II
Helper II

How to conditional format only part of a bar chart

Hi,
I have a stacked bar chart with pre defined colors and i would like to control the color of one category with conditional formatting.
For example, in the following example, I want the Done to stay green but the To Do will be defined by conditional formatting. 

yaronklein_0-1653415972700.png

 

When I go to the Format Visual pane -> Bars, I don't have the option to do formatting if I have more than one category (i.e. color):

yaronklein_1-1653416118197.png

I was expecting to see the 'fx' button next to each category as I think was the case in older versions.
I have the latest Desktop Power BI from May 2022, Version: 2.105.664.0 64-bit 

 

Do you know if it is possible to mix fixed colors with conditional formatting ones.
Thanks,
Yaron

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@yaronklein , You can not use FX(conditional formatting), when you have two measure or when you use legend .

 

Please log and idea or vote for the existing one  https://ideas.powerbi.com/ideas/

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Hi @yaronklein ,

Yes, it's only supported when there's no legend.

vkalyjmsft_0-1653980930169.png

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@yaronklein , You can not use FX(conditional formatting), when you have two measure or when you use legend .

 

Please log and idea or vote for the existing one  https://ideas.powerbi.com/ideas/

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks @amitchandak, does it mean that with conditional foramting you can only format the entire bar and it is not possible to format 2 or more using FX?

Hi @yaronklein ,

Yes, it's only supported when there's no legend.

vkalyjmsft_0-1653980930169.png

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors