Forum Discussion
What If Slicer - Single Value - Autocorrecting Issue
Hi Anonymous,
When you click the ! button on the left above, it shows the following tips. It's because of the range being too big and the numbers are being sampled. So not all value can be typed as single value.
There are the same cases below for your reference.
What if parameter help - input changes by itself after hitting enter
Whatif Parameter issues
Best Regards,
Angelia
I've tried using the slicer in its own page but here's what I get when I enter:
0.9866
Hi Anonymous,
When you click the ! button on the left above, it shows the following tips. It's because of the range being too big and the numbers are being sampled. So not all value can be typed as single value.
There are the same cases below for your reference.
What if parameter help - input changes by itself after hitting enter
Whatif Parameter issues
Best Regards,
Angelia
I also found this known issue pretty frustrating, as I had to modify my solution to allow for only 1000 values.
I also noticed that on entry of whatif values, different things happen depending on if you click "enter", "tab" or just click in the next entry box. Check this out one this video here - https://www.useloom.com/share/231d24e80fb1449d8ee00df4cb7d4b19So... As this is for this many choices of input using only sample range of values, thus making input impossible, you could also (if you still want users to narrow down numbers by input):
1. Add an extra column to the parameter table with selectable values AS TEXT e.g. using FORMAT function
2. Add a slicer with dropdown and Search field, using the newly created column which will allow for it.
voila. not that awesome. but works.
