Forum Discussion
Stacked Bar Chart not showing all values
I would like to confirm whether there is any limitation in the number of categories showing a legend because created a visualisation which is not showing all the values.
In the below image you can see under Andrich 7 cases
but when I filter the visualisation with his name, it shows 26 cases.
I would appreatiate any advice.
Regards,
Mario
As previously stated there are limitations to the number of items that can be displayed in a legend. I don't know the exact number of item that can be displayed but I would advice you to use a solution similar to what proposed by rodney-evans here:
Thread
You should be able to do this by adding a "Other" row to you dimension table. If you can send a dummy file we can work it out the, otherwise let me know and I'll modify one of my old calculations and post it here.
Br,
J
4 Replies
- Greg_Deckler
Community Champion
Anonymous When you mouse over the visual, do you get a blue "i" showing up. This is a warning indicator that the visual is essentially overloaded and only showing a sampling of data. It is a known thing in Power BI that goes back to forever. Usually happens with other visuals though. You might consider using a different visual for your display. Maybe tex628 , dedelman_clng or Tahreem24 have some creative thoughts on a better way to display?
- dedelman_clng
Anonymous Can you provide a Pbix with sensitive data removed?
- tex628
As previously stated there are limitations to the number of items that can be displayed in a legend. I don't know the exact number of item that can be displayed but I would advice you to use a solution similar to what proposed by rodney-evans here:
Thread
You should be able to do this by adding a "Other" row to you dimension table. If you can send a dummy file we can work it out the, otherwise let me know and I'll modify one of my old calculations and post it here.
Br,
J - amitchandak
Super User
Anonymous , Check if your issue is very similar to the one reported in issues -https://community.powerbi.com/t5/Issues/Stacked-column-chart-limit-for-number-of-column-series/idi-p/389139
