Forum Discussion

mogugu_84's avatar
mogugu_84
Helper I
1 year ago
Solved

bar chart total issue

I have a simple stacked bar chart like the below, each color is like one State, and the measure is like "sum of units", very simple,  i.e. like the below in March, the 7 States adds up to totally 45...
Need Help
  • v-hjannapu's avatar
    v-hjannapu
    1 year ago

    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

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

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