Table Visual is adding decimals to data

[krshaffer]

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]

@krshaffer 

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

• Data types in Power BI Desktop
• https://community.powerbi.com/t5/Desktop/Wrong-display-numbers-with-decimal-signs/td-p/305723