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

Automated colors for data labeling bar chart

Hi all, 

 

How can I automatise the color of my data label in bar char according its value, i.e when it is outside of the bar, it shold be white and when it is inside of the bar, it should be black. 

 

See in the screenshoot

 

Thanks for your helps. 

 

Dionah_0-1735580766378.png

 

4 REPLIES 4
Anonymous
Not applicable

Hi @Dionah ,

Your requirement cannot be met for the time being. There is currently no way to determine whether the data label is inside or outside the bar.
If you think this makes sense, I suggest you post your thoughts here and give it a thumbs up.
https://ideas.fabric.microsoft.com/ 
Maybe one day in the future your needs can be realized.

Best Regards,
Dino Tao

rsbin
Super User
Super User

@Dionah ,

Your other option is to change your label position to all Inside or Outside.
Then you can choose the colour best suited for your needs.

Dionah
Frequent Visitor

@rsbin of course I can, but in that case, all colors are the same. 

Greg_Deckler
Super User
Super User

@Dionah There is no way that I know of to do what you are asking based on the position of the data label. You can control the color using conditional formatting but that doesn't have an option for "inside/outside".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.