Decimal Number issue

[Anonymous]

Hi All,

I have been working on a dashboard where one of the columns in the table have decimal values 0.5 in excel,

powerbi is converting this value to 0.00 wherein all other decimal values like 0.75, 0.10 are captured correctly in powerbi. In power query editor I have made the changes to column type by changing it to decimal number also all other formats are decimal with 2 decimal places why is it only occurring to 0.5 as it rounding of 0.50 to 0.00. Kindly help to solve this issue 

Helpp !

[Anonymous]

Check to see if there is a percent format involved along the way.  0.5% would be 0.05 which in some circumstances could round to zero.  (For example if 0.5% was 0.49%, which would be 0.049 which would round to zero)