Forum Discussion

brittanyruffin's avatar
brittanyruffin
Helper I
1 year ago
Solved

Rounding Issue Stacked Bar Chart

Hi everyone, Hoping someone can help me here. I have a stacked bar chart and the total values are correct but the %s in the categories are not totalling the total values. Clearly a rounding issue bu...
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    Hi brittanyruffin ,

    Thanks for reaching out to the Microsoft fabric community forum.

    Elena_Kalina ,

    ajaybabuinturi 

    Thanks for your prompt response

     

    As mentioned by Elena_Kalina , using DAX is the most effective way to achieve the desired output.

    I’ve uploaded the PBIX file with a sample dataset and implemented the same logic. Kindly review it and share your feedback on whether it works for your current use case.

     

     

     

     

    If you are still encountering any challenges, we would be happy to assist you further.

    Best Regards,

    Lakshmi Narayana

     

     

Elena_Kalina's avatar
Elena_Kalina
Solution Sage
1 year ago

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.