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,
The matrix includes all rows even those with blanks or zero values while the bar chart automatically excludes categories (cities) with blank or zero totals from the visual, which causes the total to reduce.
This behavior is expected in visuals like stacked bar charts, as Power BI doesn’t display or count in total height categories with no visible bars.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
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 thank you, but this doesn't seem to be the answer to the issue, firstly, in this case, even in the matrix, all cities has a value, therefore it should be the same for the bar chart. plus even if there are zero value cities, it may display more rows in the matrix than in the bar chart, but the SUM total should still be the same
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 TeamHi
thanks but as i described that all cities do have values, and the total does not match.
please see the sample pbix file here
https://drive.google.com/file/d/1RJWD3k7g0xH886iREEC1cywWCnnWzlzV/view?usp=sharing