Forum Discussion
Continued ContributorLegend not working correctly in stacked column chart
It seems that Power BI simply can not include/calculate all the customers's data.
If you filter data showing the results for a few customers only then the trend will be OK.
Resolver IILet's just speculate a bit.
How could a chart represent, for example, 1000 customers, if 200px(for example) is available only.
If 1px is for a customer, then for 1000 customers at least 1000px are needed, but what we have is 200px only.
Continued ContributorSergiyI agree with you - would be silly to try to cram 1000 customers into 200 px. I like what excel does here:
(i) flip into a clustered column chart instead of a stacked if try a power pivot table, and
(ii) if you then try to go stacked, it will fail, giving a warning of a 255 max series limit.
FWIW - I think something like the foregoing would be a lot better because, at least for me, it was easy in PBIX to get the chart, not see that I was only capturing half my series, and proudly publish the data to my peers, not realizing that the data series was incomplete! Darn! And I was so proud of my work! So, to me the bug is mostly the alerting. This said, charting NIRVANA would be a chart that collapses the smallest n customers in the stack.