Automated colors for data labeling bar chart

Question

Hi all,&nbsp;&nbsp;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.&nbsp;&nbsp;See in the screenshoot&nbsp;Thanks for your helps.&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

Dionah&nbsp;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".

rsbin · Answer

Dionah&nbsp;,
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 · Answer

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

anonymous · Answer

Hi&nbsp;Dionah&nbsp;,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/&nbsp;Maybe one day in the future your needs can be realized.Best Regards,Dino Tao

Forum Discussion

Automated colors for data labeling bar chart

4 Replies

Related content

Data Labels Colors

Automated refreshes

Button Slicer - Label text colors not working?

Automating API link updates

PowerBi and Power Automate