Forum Discussion
what- If parameter User Input rounds off incorrectly
I have created a sequence from 1 to 60,000 using what if parameter ,When you put a value and enter it rounds off in a weird way.(As you know slider is useless in this scenario as you can't really select a desired value when the sequence is too big)
For an example when entered
1 to 31 it changes it back to 1
32 to 91 it changes it back to 61 and so on it was totally random and I am super frustrated.
Slider is useless in this scenario as you don't have the flexibility to select the desired number as the sequence is too big (For example 49249)
Can anyone help me with this issue please ?.
7 Replies
- parry2k
Super User
deevs afaik it is a known issue and there is a bug reported on issue forum, do put your comments on the issue so that it can be solved. I don't have the link to the post of the issue but you can find it on issue forum here.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
- deevs
Helper III
hi parry2k,
Any chance you can direct me to that link as I couldn't find it .
- Icey
Community Support
Hi deevs ,
The issue is caused by 1002 sampling limit on slicer visual.
Please refer: What-if parameters do not work due to 1002 sampling limit on slicer visual (CRI 115536429).
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- afonsofelicianoFrequent Visitor
Hello deevs as you can see, you may have the same problem and include or relate to the power bi forum according to the following links:
https://community.powerbi.com/t5/Issues/bug-What-If-with-decimal-numbers/idc-p/1173208#M58316
https://community.powerbi.com/t5/Desktop/bug-What-If-with-decimal-numbers/m-p/1158010#M524368after that I contacted the power bi support and I was answered:
_Hi Afonso,
Thank you for your time in teams meeting.
We apologize for the inconvenience caused.
Summary of the call.
Issue: What if parameter with decimal numbers not working as expected.
1.After getting this case, we analyzed from my end.
2.Raised a high severity ticket to the Product team.
3.They confirmed that,
a. The problem comes from the number of values the visual is retrieving.
b. So if there is more than 1002 different values, some may not be taken.
c. Anything with more than 1002 values will show the rounding problem.
d. This visual does not have a hi-density mode that would take more samples.e. It’s an idea to submit to the Ideas web site.
The Product team will take the priority of the deployment based on the votes polled for the idea. The idea which polled more votes they will take as priority.
Our Product team pushes improvements and features on weekly basis. These improvements are planned well in advance. But there are some of the improvements which will have lot of dependencies due to which it takes long time and sometimes it becomes extremely hard for us to define an ETA even though we have a road map of improving the feature. We hope you understand the complexity here. Our focus is always on improving customer experience and giving what customer is looking for sooner or later._
basically when you have more than 1002 values the visual cannot behave in the correct format, causing the bug.
unfortunately, we need a correction as soon as possible, since many companies here in Brazil use this functionality frequently, but until today microsoft has not performed the correction.
- Icey
Community Support
Hi deevs ,
I found that you have an workaround on this problem from another post. Could you share us a pibx template?
Best Regards,
Icey
- deevs
Helper III
Hi Icey ,
I will create a template from my data model and share it tomorrow 🙂
Thanks,
Deevs
- rbriga
Impactful Individual
If you've reached this thread searching for help,
Power BI now offers a workaround: Fixed decimal numbers.
Victory!
This forces the decimal number to remain in the correct form throughout GENERATESERIES()- by using the CURRENCY() function on each value:
Parameter = GENERATESERIES(CURRENCY(0), CURRENCY(3), CURRENCY(0.01))