Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rounding issue

Hello everyone,
I'm facing an issue with the rounding of the numeric values in Power BI. I have sales data and while calculating the profit percentage I'm getting some weird values (57482316902456.00%). When I see the values in data view and make the column to 15 decimal points then it seems fine (8547.20000000000000000) but when I plot the measure of this column where I'm doing sum it shows some different values while doing 15 decimal points of measure (8547.199900000000007). I already round the column at power query level where I'm rounding to two decimal places but, still it is showing some values after 2 decimal places when plotted on the visual. So, is this something expected? If yes, could you please explain why we have this behavior in Power BI and how I can handle this?
Any help on this is highly appreciated.
Thank you.

1 Reply

  • Anonymous Decimal numbers are always approximations. Use the Power BI field formatting to define the visible digits.