cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect values in table visual; values ~0.00001 below

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:

drobson997_0-1638267118446.png

 

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

drobson997_1-1638267216477.png

Thank you for your help!

Status: Investigating

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

vyingjl_0-1638327023385.pngvyingjl_1-1638327035340.png

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

Comments
v-yingjl
Community Support
Status changed to: Investigating

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

vyingjl_0-1638327023385.pngvyingjl_1-1638327035340.png

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

drobson997
New Member

Hi @v-yingjl