Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Decimal Number issue

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 !

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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)