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

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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