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,
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!

 

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.