Stacked Column Chart showing wrong value total on Y-axis

[Anonymous]

I have a stacked column chart visual that is supposed to show a total amount for the year 2020 of 2594. However, looking at the Y-axis, it's clear to the eye that this column barely reaches 1400, the maximum of the chart. I've checked the Start and End values of the Y-axis in the Format pane, and they both are set on Auto (which means it should dynamically change based on the total values).

What is going wrong here? I have no extra filters applied, and all the sources come from the same table. If I add in each "Retailer" one by one, then the number seems correct. But as soon as the total value goes past a large value (like 1500), then the scaling on the visual becomes wrong and does not register more.

[Pragati11]

Hi @Anonymous ,

You can't judge looking at the y-axis what your total value is as it is a stacked chart.

Under format settings, ENABLE Total Labels as shown below:

This will help you in seeing the right Total value.

Thanks,

Pragati

[Anonymous]

Still incorrect it seems.

[Pragati11]

Hi @Anonymous ,

Is there any visual level filter on your stacked chart?

Are you moving the same unique count to the chart as in the card?

I tried to reproduce similar unique counts for the data I have, I see the totals match in my scenario:

Thanks,

Pragati

[Anonymous · Accepted solution]

I found the answer I was looking for. 

https://community.powerbi.com/t5/Desktop/Stacked-bar-chart-with-many-legends/m-p/732246

It seems that there is a limit of 60 legends. Any more than that and it will show a limited amount of the data, showing via an algorithm the most relevant ones. This is also known as High-Density Line Sampling (https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-high-density-sampling).