Showing results for 
Search instead for 
Did you mean: 
christheo New Member
New Member

Legend limitation?

I'm using a stacked column chart visualisation, and have 19 data series, each is a country. I want each of these 19 to appear in the stack, but it seems I've reached a limit of 15. Unselecting one country from the visual filter will allow another country to appear but still that maximum value of 15 persists. 


I wasn't aware of a hard limit. Is there any way to get past this limitation? Am I doing something wrong perhaps?





Moderator v-qiuyu-msft

Re: Legend limitation?

Hi @christheo,


In your scenario, does the chart contain large amount of data? If there are too much data, it will have a warning message to prompt us to filter less data like below:





Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
apollnor Regular Visitor
Regular Visitor

Re: Legend limitation?

Same issue, we are looking at working hours in projects we have over time. We are working on way more than 15 projects pr month, so if we drill up to top lever which is year we only see 3500 hours, where the fact is actually 35000 hours. Wrong sums.


The warning needs to be bigger when limits are reached! We had to find this out the hard way!

Helpful resources

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 427 members 3,888 guests
Please welcome our newest community members: