Forum Discussion

jatneerjat's avatar
jatneerjat
Helper V
8 years ago
Solved

Number values are getting round off automatically

Hi,

 

I have a column which have decimal places upto 9 and for every row it is different

 

 

when i drag this column into power bi then it automatically round off to two decimal places.

 

then I changed the value decimal places to 6 but then it added extra zero after two places

 

 

 

How can i get my original value into power BI.

 

Thanks

 

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi jatneerjat,

     

    This is not a PBI issue this is rounding, your number as 9 decimals but the 7 decimal place is 8, so when rounding it will go to 0, then the rest of the numbers will also go up to 0 until you get to the 2nd decimal that is 6 that rounded gives 7.

     

    If you place the 9 decimals on your table you will get the original number.

     

     

    Regards,

    MFelix

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi jatneerjat,

     

    This is not a PBI issue this is rounding, your number as 9 decimals but the 7 decimal place is 8, so when rounding it will go to 0, then the rest of the numbers will also go up to 0 until you get to the 2nd decimal that is 6 that rounded gives 7.

     

    If you place the 9 decimals on your table you will get the original number.

     

     

    Regards,

    MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    jatneerjat,

    Instead of changing decimal places in visuals, you can directly click the column in FIELDS pane and then change decimal places to 9 under Modeling option.



    Regards,
    Lydia