The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have set up my what if parameters and now have fields where users may add the percentage which they require. However, when I add, for example, 0.14865 , the Power BI field defaults back to 0.1489 which is incorrect.
Is there any way to fix this? Thanks in advance
Solved! Go to Solution.
Hi @Anonymous
To my understanding the maximum number of decimal points you can increment in a parameter is 4.
I think your rounding error is due to the formatting of the value within your parameter.
Try selecting the paramater value and changing the number of decimal places from auto to 4.
Hope this helps
Thanks,
George
I have got the same problem but then with whole numbers.
For example, I'm typing 104 and it gives 105, when typing 103 I'm getting 102.
What is going wrong ?
This does work: (but I want to ad values varying from 1 tot 4 diggits number)
@Anonymous Just to add, you can do that under the "Modeling" section under "Formatting" There is a dropdown that allows you to configure that format to the number of decimal places you want.
Hi @Anonymous
To my understanding the maximum number of decimal points you can increment in a parameter is 4.
I think your rounding error is due to the formatting of the value within your parameter.
Try selecting the paramater value and changing the number of decimal places from auto to 4.
Hope this helps
Thanks,
George
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
41 |