Forum Discussion
Do not rounding
Hello All, some of the following values are not 100. For instance 0.9978 or 0.9915, and I want to work with these exact numbers in visuals. But Power BI rounds them. Meanwhile, I do not use the rounding option in the power query. How can I get the exact numbers without rounding?
4 Replies
koorosh Strange. I can't replicate that. See PBIX attached below signature.
koorosh OK, I spoke too soon. I was able to replicate it by switching it to Whole number instead of Decimal number. The interesting thing is that when I then switched it back to Decimal number, the rounding persisted. I had to do a Refresh in order to get the visual to revert back to showing the decimal number instead of 100%. Weird.
Hi Greg, for your information the resource data is a sharepoint list as following setting.
I created an example sharepoint list to check the problem. The interesting point is that is fine with no rounding.
Really helpless to find the solution.
Greg, I increased the number of decimals to 9. The problem exists yet!
