Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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.
@MarioCadena Change the data type to decimal number in the power query window like below
You can refer to below links as well
Proud to be a Super User!
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |