Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone!
I'm with a serious problem.
I want to show in my report numbers with 6 decimal places.
When editting queries and preparing data, the values are ok, like 0.891344 but in the presentation view then value transforms to 0.891300.
Even if I raise decimal places, just more zeros are added.
Any help?
Thanks!
Solved! Go to Solution.
I'm wondering if the Query Editor is causing the problem. Can you please remove any formatting on that column in the Query Editor and make sure it is using the Decimal Number (and not Fixed Decimal number) up in the Query Editor.
This sounds like something I've helped with before, but I can't find the resolution.
Now it worked!
Beyond remove any formatting, I had to put a "CONVERT(DECIMAL(28,10)," in the native query source - although the column type is already that - and rebuild totally the query from zero in Query Editor, removing any transformation in the column.
Thank You @Phil_Seamark!
Yes, when i use the formatting, is added zeros, but not values.
Here is some examples:
Are you using a Decimal data type, or Fixed decimal (like currency?)
Decimal type.
I also tried fixed decimal, but didn't work too.
I'm wondering if the Query Editor is causing the problem. Can you please remove any formatting on that column in the Query Editor and make sure it is using the Decimal Number (and not Fixed Decimal number) up in the Query Editor.
This sounds like something I've helped with before, but I can't find the resolution.
Now it worked!
Beyond remove any formatting, I had to put a "CONVERT(DECIMAL(28,10)," in the native query source - although the column type is already that - and rebuild totally the query from zero in Query Editor, removing any transformation in the column.
Thank You @Phil_Seamark!
Hi everyone!
I'm with a serious problem.
I want to show in my report numbers with 6 decimal places.
When editting queries and preparing data, the values are ok, like 0.891344 but in the presentation view then value transforms to 0.891300.
Even if I raise decimal places, just more zeros are added.
Any help?
Thanks!
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |