Forum Discussion
Help with 100% Stacked Bar Chart values showing 101%
Hi can anyone help me explain why in the attached 100% stacked bar chart the values are actually counting to 101%
Hello, FelixElliott ,
depends how you built the chart.
If you have categories, perhaps you have some blanks in it so that could make it look weird.
If you measures stack on each other, you can check formatting if they shared the same decimal places etc. Or again perhaps check blanks.
2 Replies
- vojtechsima
Super User
Hello, FelixElliott ,
depends how you built the chart.
If you have categories, perhaps you have some blanks in it so that could make it look weird.
If you measures stack on each other, you can check formatting if they shared the same decimal places etc. Or again perhaps check blanks.
Thanks for the reply from vojtechsima , please allow me to provide another insight:
Hi, FelixElliott
Your observations are quite thorough; however, I feel it’s necessary to explain that the issue you’re encountering is specifically related to the number of decimal places retained in the final results when calculating percentages for visual objects. This often leads to discrepancies due to common rounding errors.
For instance, I created a visual object using sample data at random.
We can manually reduce the error by adjusting the following settings:
Here are the final results:
Please find the attached pbix relevant to the case.
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
