Table Visual is adding decimals to data

krshaffer · ‎11-07-2019

I have a user that has developed a Power Bi report which shows out to 15 decimals if needed in a table visual. When looking at the "Data" view in desktop, the data in question shows ###.650000000000000. When this same record is viewed in a Table visual in the "Report" view, the item shows ###.650000000000100. 15 decimals is needed. I haven't found anything to suggest why this is happening. This is random across various records. Data is coming from an Excel file. The data in the source does not have the "1".

In addition, a calculated column is created using Calculate(Sum()) and this item. In the data view, the "1" doesn't show up, but it does in the "Report" view in the table visual.

Looking for anyone who has come across this issue and how it was resolved.

v-chuncz-msft · ‎11-08-2019

@krshaffer

Check the links below and create a support ticket for assistance if necessary.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.