Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
The attached PBIX is a simple Revenue By Customer (anonymized). The data looks like this. I also have a date table.
When I do a stacked revenue chart without a Legend, the numbers sum correctly (see first tab).
When I do a stacked revenue chart with a Legend, data goes missing and the numbers sum incorrectly.
I've prowled through the support boards and am not finding issues that suggest user error. Is this a bug? It's such a simple table with 1:1 relationships that I'm not seeing the user error here.
Test File Stacked Chart - Revenue By Customer
Thank you
Charlie
Solved! Go to Solution.
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.
Hi @charleshale
The link to the file you provided is not valid.
I'll try to make a guess of what is happening. I think you have either Customer or Date column sorted by another column. If I am right make it sorted by itself and check the result.
Is my guess correct?
Apologies for the broken link. Here's it on onedrive: https://1drv.ms/u/s!AkwttVUD7SbrjCLxQ1M6jf0xeryf
Hmmm - is this doing that?
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.
I agree - seems like a bug, right? I'd expect the stacked chart to be able to handle N customers up to the memory limits, like excel!
Let'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.
@SergiyI 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |