Forum Discussion
bar chart total issue
Hi mogugu_84 ,
If all cities have values, the matrix and stacked bar chart totals should match. The issue is that Power BI’s stacked bar chart may skip some cities due to its data reduction for performance, causing a lower total than the matrix which shows all data, like your correct 4708 total. Zero value cities might add rows in the matrix but don’t affect the sum, so the discrepancy is purely visual.If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Harshitha.
Community Support Team
Hi mogugu_84,
Thank you ExcelMonke, for your response regarding the Issue.
Thank you for reaching out to the Microsoft fabric community forum.
Here are the few steps which you may follow to resolve the issue :
1.Make sure that the relationship between your tables is properly established.
2. Ensure Your DAX correctly sums the Total Units at both the State and City levels.
Please find the attached file for your reference.
If you're still facing any issues, consider sending sample data.
You can refer the following links:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Solved: How to upload PBI in Community - Microsoft Fabric Community
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a'Kudos' so other members can easily find it.
Thank You!
Hi mogugu_84,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.