Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Automatic number formatting showing 17 decimals instead of 1 as in source

The number in source excel is 0.2, but in graph it shows as 0.19999999999999998.


I tried rounding the number in query editor, it didnt help. It helps to format the number with set number of decimal places, but in my model I appreciate the option of having it automatic as some values have decimals and some are in thousants.

 

Screenshot:

 

Status: Accepted
Comments
v-haibl-msft
Employee

@Zodiak

 

I think your issue is same as this one. It has been reported internally (CRI 29369779) and the fix will be included in Mar 2017 release of Power BI Desktop.

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Status changed to: Accepted