Rounding Off Automatically

[MarioCadena]

I have the following list in power query

When it is exported to the desktop, it is rounded up automatically; even though, the format is decimal.

Any ideas about why this is happening.

Regards,

[negi007]

@MarioCadena Change the data type to decimal number in the power query window like below

You can refer to below links as well 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#:~:text=Power%20BI%20Deskt....

[amitchandak · Accepted solution]

@MarioCadena ,Open Data Transformation/Edit Query. Check The data Type there It should number/decimal not int.

Or Right click on the table and open Advance Editor. And Check for this column. This should Number/numeric. Not INT64. If it is int change it to number.

Please keep a backup file, before doing this.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

@amitchandak @MarioCadena 

Hi all, I have the same problem with round off the values, however this numbers coming from a measure, column it is in number format as you explain  above. What i am doing wrong?

Thank you in advance