How to show all data labels - clustered bar chart

[Toews8612]

As can be seen in the clip, some data labels are missing for the green bars, but some are showing. The font size is set to minimum and there is no way to change the bar widths that I can find. There is also no label density setting available, nor any other setting I can find that would impact this behavior in a favorable way.

Ugh. Is there any solution? 

[Toews8612]

Thanks a ton Rita! Your suggestions made me look at the axis options closer. Simply increasing the X axis minimum category setting solved the problem. My bad for not thinking of that earlier.

And you're absolutely right on the horizontal orientation. I was favoring data density over optics.

I also think the three-chart approach for illustrating the delta's for each time period would be better, but there is a table and several slicers for the seeing the specifics , so real estate is an issue. I intend to experiment with it regardless.

Your prompt and thorough reply saved me a bunch of time and was hugely beneficial!

Thanks again!

[Ritaf1983]

Happy to help♥️

[Ritaf1983 · Accepted solution]

Hi @Toews8612 
The engine "hides" the labels when it determines there aren't enough pixels to display them.
Therefore, the way to still see the labels is to enlarge the chart or reduce the font size.

From an effective data visualization perspective, it’s very difficult for users to read vertical labels—notice the movement of your neck when trying to read them.
Therefore, I strongly recommend breaking the date into a hierarchy of day of the week and date , and adjusting the chart for a horizontal display (if you have a lack of the place in your canvas)

If the goal is to show the progression of the two metrics over time and to understand the differences between them, I’d recommend splitting it into three small charts:

1. One for each category
2. A chart for the difference between the two metrics

This layout will make the information much more intuitive and aligned with how the brain processes data. It will also make it easier to identify the differences at a glance.
(Of course, just a suggestion for your consideration!)

The pbix with all the options I gave is attached.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.