Forum Discussion
Solved
No data labels in Stacked column chart
I created a Stacked column chart and turned Data labels to On. However, no data labels show in the chart.
I tried changing the Display units of the Data labels to each of the different options, which made no difference. I checked that the Color of the Data labels is not the same color as the columns and not thereby blending in.
I thought maybe there were no data labels due to too much data being represented. I tried selecting various options in the slicers I put on the page so as to reduce the amount of data being represented but there were still no data labels.
Help?
- I've had this issue also, it was indeed because there were to much distinct bars so there was no room to display the data labels. You can test 2 things. 1: change to a line graph and see if the data labels work in that visual to rule out some bug or something, and 2: limit the amount of bars by filtering in your query (not in slicer). I suspect the data labels apear when limiting the amount of bars (to lets say 5), you can work your way up from there to see at what point the data labels disapear.
Als it sometimes helps to widen the visual and/or lowering the data label size.
3 Replies
- SanderBeukers
Advocate I
I've had this issue also, it was indeed because there were to much distinct bars so there was no room to display the data labels. You can test 2 things. 1: change to a line graph and see if the data labels work in that visual to rule out some bug or something, and 2: limit the amount of bars by filtering in your query (not in slicer). I suspect the data labels apear when limiting the amount of bars (to lets say 5), you can work your way up from there to see at what point the data labels disapear.
Als it sometimes helps to widen the visual and/or lowering the data label size.Thank you, SanderBeukers. Exactly as you described.
