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

     

     

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

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.