Stacked Bar Chart not showing all values

[MarioCadena]

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

[tex628 · Accepted solution]

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

[Greg_Deckler]

@MarioCadena 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]

@MarioCadena Can you provide a Pbix with sensitive data removed?

[amitchandak]

@MarioCadena , 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...