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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Angel22
Frequent Visitor

Conditional formatting data labels not working correctly in clustered column chart

Dear All,

 

Im trying to format data labels that are already in %, to color negative numbers red and positive green. (Power Bi Desktop)

 

The selection of number and percentage is blocked, number is grayed out.

 

I tried the solution below but does not work, it displays all numbers as red.

 

I would appreciate if someone could help me with this issue.

 

Thanks in advance

I use Power Bi Desktop June 2022 version

 

1.PNG

6 REPLIES 6
Angel22
Frequent Visitor

Hi , amitchandak thank you for your answer.

 

Im not an expert, but what do you mean with row values? 

Those values are the total QoQ% difference between years coming from a quick measure.

 

@Angel22 , You are expecting color based on the bar(row) value. and I doubt that label formatting as of now works with overall value. Plot this measure on card visual and check does it follow that value.

 

Also, check the condition on the Value/bar formatting and check

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

Hi , amitchandak

 

Creating a card visual and trying exactly the same parameters that i used for the data labels (but in effect - background) works perfectly.

So i dont get why it should not work for the data labels if the variables are the same.

 

2.PNG

@Angel22 , Log an issue or Idea

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

Ok perfect, i reported it as an issue

amitchandak
Super User
Super User

@Angel22 , As far as I know as of now the label formatting work on grand total not on the row values.

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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