Forum Discussion
Too many values: PBI Stacked area chart trimming values
Hi,
We are using a Stacked Area Chart visual to display data, but the visual is showing only a portion of the total. It says too many values, not showing all data.
Ideally, one of the benefits of this visual is that it can show the aggregated values for a number of (in my case) local governments. In doing so the user can look at the chart and see the total labour force for the state. Unfortuanately the chart trims the number of people and the visual shows the wrong number. This is risky for the business decision-making and potentially can cause reputational damage to our team.
This is a known issue, but I don't know if there is a way to fix it. Any recommendations on fixes would be appreciated.
Thanks,
Brent
2 Replies
Hi Brent_BC ,
The number of series that can be displayed in bar and column charts is 60:
Apply data point limits and strategies by visual type - Power BI | Microsoft Learn
You can add another “Other” row to the table for data that is not shown.
Here is the thread with similar issue that have been resolved hope this helps:
Solved: Stacked Bar Chart not showing all values - Microsoft Fabric Community
You can also give your thoughts at this link:Home
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I filtered out about 3/4 of the values in the x-axis. It now aggregates the values correctly, rather than showing the population to be about 400,000 people less than actual. Not a good solution, but better than the chart showing the wrong values. Clearly this needs to be addressed by MS.
