Forum Discussion
Stacked Column Chart showing wrong value total on Y-axis
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.
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).
4 Replies
- Pragati11
Super User
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
- 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
