Number values are getting round off automatically

[jatneerjat]

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

[v-yuezhe-msft]

@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

[MFelix · Accepted solution]

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

[jatneerjat]

Thanks @MFelix.I did what you mentioned and it works.