Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I'd like to display data labels on a stacked bar chart.
It works fine without a legend:
But when I add a legend to this chart the data labels disapper on the smaller bars:
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!
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.
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:
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!
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:
Here are a few things you can check on your side :
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!
User | Count |
---|---|
84 | |
73 | |
70 | |
42 | |
35 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |