Incorrect values in table visual; values ~0.00001 below

[Anonymous]

Hi all, 

I am having an issue with the table visual where values appear to be slightly below (literally 0.00000001) the data value imported. 

The example I have is in my data (imported from an excel) where the value is clearly 19.4, but once imported and added to a table visual, it comes up as 19.3999999999999999. 

I do not even know where to start in fixing this, so any help would be really appreciated ❤️ 

I have included screenshots too, apologies I have to cover a lot of the information. 

See here it is 19.4 in my excel file:

Now in my table visual on my dashboard, it is 19.3999999999

Thank you for your help!

[v-yingjl]

Could not reproduce it in my side as far as my test.

What's the data type of this column in excel and Power BI Desktop? I have set number type in excel, it shows decimal number type in Power BI Desktop and works fine in the visual.

Best Regards,
Community Support Team _ Yingjie Li

[Anonymous]

Hi @v-yingjl

Firstly, apologies for the delay in responding. 

To answer your question, the data type in excel is just general, because that column consists of both values and text. The case is the same for the data type in Power BI as we cannot set it to numbers because of the text entries. 

All the best,

David Robson