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

mogugu_84's avatar
mogugu_84
Helper I
1 year ago

Hi

thank you, I'm travelling at the moment but will definitely check and feedback as soon as I can. 

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

Hi mogugu_84 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

 

Best Regards,
Harshitha.
Community Support Team.

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

    Hi mogugu_84,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Best Regards,
    Harshitha.
    Community Support Team.