How to show exact values of my source file into power bi without rounding them.

[Anonymous]

In my source file I have values like 3.4, 2.3, 1.5 etc., when I load my source file into desktop, it's rounding them to nearest integer like 4,2,2 etc. But, I want my values exactly as shown in my data source file. 

[amitchandak]

@Anonymous , Open power query and check the data type, if the data type is whole number, change it to decimal

Option in home tab of power query

or check column tools by clicking on column in data view

[Anonymous]

Yeah, I've changed the data type from whole number to decimal number but, still have the same issue.

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution to close this thread.

If you still need help, please share relevant screenshots for further research.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

At what step did you make the changes?

Please delete the original step 'Changed Type' before you modify the data type.

Best Regards,
Community Support Team _ Eason