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
Bilal_Niazi123
Frequent Visitor

Conditional formatting in Bar Chart

Hi,
I have a stacked bar chart where I want to apply conditional formatting. The y-axis is 'Job Name' and the x-axis has all numeric columns that are showing the number of days. I want to apply conditional formatting of these number of days columns.
For example, if 'opened - sent' <12 then the bar color should be green otherwise red.
If 'Sent - 1st interview' < 5 then green otherwise red.
If '1st - 2nd interview' < 5 then green otherwise red and so on...
Kindly check the attached image to get a clear picture of my requirements. Any help/suggestion will be appreciated.
Thank You
Bilal_Niazi123_0-1687771525762.png

2 REPLIES 2
TomMartens
Super User
Super User

Hey @Bilal_Niazi123 ,

 

you can not achieve what you are looking for, because currently the default visuals are not supporting conditional formatting when multiple values are used in the bucket list or when a categorical variable is used in bucket list.

 

Next to that, there will be a problem with the legend (even if you do not show the legend), how do you imagine  a legend when one jobname is green and one jobname is red?

You can only achieve what you are looking for by using Deneb: https://deneb-viz.github.io/

Hopefully, this provides some insights to get you started.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi @TomMartens , 
Thanks for your response. Unfortunately, the Deneb bar chart is not allowing me to use more than one field on a column. Is it possible with hard code? 
Help please if you think it is the only solution of my requirements. 
Thanks 

Bilal_Niazi123_0-1688459620045.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.