Forum Discussion
What If Slicer - Single Value - Autocorrecting Issue
- 8 years ago
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
Hello everyone,
I also faced with this annoying behavior and found a workaround. Just wanted to share here wishing it helps others.
After creating what-if parameter, change slicer type to "greater than" or "between" instead of "single value". And then, change default measure formula to MIN(parametercolumn) instead of SELECTEDVALUE(paramentercolumn,0).
Lastly, you can hide slider handle using format pane and hide second input box by resizing the visual.
Done: End user experience is same and we have full list of values available!
- MMMarcius3 years agoNew Member
Great workaround, thanks for that!