Forum Discussion
::: How create a simple calculator for the user to input values :::
Hi Anonymous ,
This is a know error on the type of slicer of the parameters especially with big numbers one option can be to do to add a column with the same values of parameters but on text format. Sort that column by the parameter and change the slicer to a selected list with single select.
Then turn on the search option on the slicer:
hello Guys!
Tks for help me!
But I need anything better, that the user can interact.
At Excel, is easy... I'll do a UserForm with a "TextBox" where the user can interact, with any number... here in Power BI with long numbers gives error 😅
Super UserHi Anonymous ,
You can create the what if parameters:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
Thanks MFelix ,
I saw this, but when the number range is quite high ... it does not work well,
example: I put an initial range from "0" to "100,000"
if the user types any integer into the text box of the object and typing "enter" the number changes,.... example, if I type "99" and enter.. the value changes to "100".
the range range is already at "1" as shown in the formula... is there any way to fix this?
- MFelix
Hi Anonymous ,
This is a know error on the type of slicer of the parameters especially with big numbers one option can be to do to add a column with the same values of parameters but on text format. Sort that column by the parameter and change the slicer to a selected list with single select.
Then turn on the search option on the slicer:
HI Anonymous,
Yes, this should be a known issue when you use a big number input to what-if parameter filter. It will auto redirect to the nearest number of the slide bar located.
For this scenario, you can change the slicer to the range mode(before, after) and this issue will disappear.
Regards,Xiaoxin Sheng