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.
Well known issue:
what-if parameter, p:
p = GENERATESERIES(0, 400, 0.01)
--> Problem: The selected value will be rounded up or down
The problem seems to be fixed for whole numbers, is there a workarround for decimals?
(I know the input should be limited to 1000 Values but it is not possible for calculation)
Solved! Go to Solution.
Hey @Anonymous ,
that's because you have more than 1002 values. Then it will take random values in the whole range.
Check the following article on what exactly is the problems and what alternatives are there:
I have solved this issue based on Denis suggested solution and attached a Rounddown function to it. This means if a user will input 5.00 the float might round up to 5.01 in any visual. To avoid that and other issues I use the rounddown(min(input),2)
--> 5.00
Thank you Denis for your quick reply.
Great link!
If I use your 2. option of the suggested solution and change the type of slicer to "Less than or equal to" the problem still occurs.
Hey @Anonymous ,
that's because you have more than 1002 values. Then it will take random values in the whole range.
Check the following article on what exactly is the problems and what alternatives are there:
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 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |