Do not rounding

[koorosh]

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?

[Greg_Deckler]

@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.

[koorosh]

Greg, I increased the number of decimals to 9. The problem exists yet!

[koorosh]

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_Deckler]

@koorosh Strange. I can't replicate that. See PBIX attached below signature.