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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
DN200
New Member

Adding Legend Removes Data Labels

Hello,

 

I'd like to display data labels on a stacked bar chart.

It works fine without a legend:

DN200_0-1750187621455.png

 

But when I add a legend to this chart the data labels disapper on the smaller bars:

DN200_1-1750187790406.png

 

I thought that it was a sizing issue, that perhaps I had too many bars being displayed at once. But when I drilled down into one of the bars, the lables appear!

DN200_3-1750188154385.png

This drilled in level has TWICE as many bars as the first level and yet all of its data is annotated. 

 

It seems like there is a bug with how the data labels and legend are interacting.

Any help would be greatly appreciated.

 

 

4 REPLIES 4
burakkaragoz
Community Champion
Community Champion

Hi @DN200 ,

 

This is a great observation, and you’re definitely not alone—adding a legend in Power BI stacked bar/column charts can sometimes cause data labels to disappear, especially on smaller bars. It’s not just a sizing issue; it’s actually due to how Power BI manages label rendering priority when multiple series (legend values) are present.

When you add a legend, Power BI tries to avoid overlapping labels and prioritizes which ones to show, often skipping smaller segments to keep the chart readable. But as you noticed, when you drill down (and the number of visible legend categories drops), the labels reappear—even if there are more bars in total.

A few things you can try:

  • Increase the font size or reduce the number of legend categories to see if more labels appear.
  • If possible, use “Data label density” (if available in the Format pane) to control how many labels are displayed.
  • Consider switching to a clustered bar/column chart if your scenario allows, as these sometimes handle labels differently.
  • As a workaround, you can also add a tooltip or custom visual to display the values on hover for the smaller bars.

Honestly, this does feel like a rendering limitation or minor bug in how Power BI handles data labels with legends. You’re not doing anything wrong, and many users have run into similar behavior.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Thanks for the detailed explanation!

Decreasing the font size of the legend or the data labels doesn't help. Power BI's lowest font setting is 8.

Data label density is pretty intriguing, but I don't have access to that functionality.

Hi @DN200 ,

In Power BI, the smallest font size allowed for legends and data labels is 8pt, and unfortunately, there’s no way to reduce it further. If your visual still appears cluttered at that size, consider the following alternatives to improve readability:

  • Break the chart into multiple smaller visuals by category or apply filters to narrow down the data view. This helps reduce visual noise and makes the report easier to interpret.

Regarding the Data Label Density feature, it’s not universally available across all visual types and may require the latest version of Power BI Desktop. If you're unable to find this option:

  • Ensure you're using a compatible visual, such as a clustered bar or column chart.

  • Confirm that you’re on the most recent version of Power BI Desktop.

  • If you're working with Power BI Report Server, be aware that certain features might be missing compared to the Power BI Service or Desktop versions.

Hope this helps!!

 

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!



v-aatheeque
Community Support
Community Support

Hi @DN200 
Thanks for bringing this up!

We’ve tried to reproduce the behavior on our end using a basic sample dataset, and in our case, the data labels appeared correctly on the stacked bar chart, both with and without a legend, and across drill-up and drill-down levels.

 

Below are the screenshot for your refernce: 
vaatheeque_0-1750226145939.png

vaatheeque_1-1750226210658.png
vaatheeque_3-1750226241542.png

Here are a few things you can check on your side :

 

  • Ensure you're using the latest version of Power BI Desktop. Sometimes, display issues get resolved in newer builds.
  • Double-check the formatting options under Data labels make sure label visibility isn’t conditional on size or overlap.
  • If the bars are very small or the space is constrained, Power BI may automatically suppress some labels to reduce the font size.
  • Try repositioning the legend or resizing the visual to see if that impacts label visibility.

If the issue still persists, feel free to share a small sample PBIX file and we’ll be happy to take a closer look!

Please show the expected outcome based on the sample data you provided.


How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Hope this helps!!

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!



 

Helpful resources

Announcements
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.