Rounding Issue Stacked Bar Chart

Hi brittanyruffin,

Wanted to let you know that each category's percentage is individually rounded, but when you sum all these rounded values, the total can end up being more or less than 100%, even though the actual math behind the scenes is correct.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

Hi brittanyruffin 

This discrepancy occurs because each category is rounded separately, while the total is obtained not by summing the rounded values of the categories but simply by rounding the overall value. However, if you want the total to match the sum of the rounded category values, you can use DAX for this—create a formula to calculate the rounded values of the categories and use this formula instead of the automatic total.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

Hi brittanyruffin ,

Thanks for reaching out to the Microsoft fabric community forum

To help us understand your issue better, please share sample data that clearly shows the problem (in text or table format, not a screenshot), without including any sensitive or unrelated information, and also show the expected result based on that data. If possible, share the PBIX file as well, provided it doesn’t contain any sensitive information.

Looking forward to your response.

Best Regards,

Lakshmi Narayana