Forum Discussion
What If Slicer - Single Value - Autocorrecting Issue
Hi all,
I am having trouble understanding why my single value slicer is behaving like this:
Here, I am typing out the target I want to set in my "What If" slicer.
This is what happens when I press enter:
It seems the field autocorrects to a value close(?) to the value I entered.
If I switch the slicer to a drop down list, then I can see the value I originally wanted.
Has anyone else also experienced this issue?
I know there is no issue with decimal places because I've tried increasing it with the issue still occuring.
I have also tried not setting the Data Format to Percentage but still no luck.
Any help, even letting me know this is a known bug, would be great.
Cheers, Leo.
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
9 Replies
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!
Great workaround, thanks for that!
What is the forumla for the GENERATESERIES function for the parameter?
I changed mine to this
Parameter= GENERATESERIES(0.0001, 20, .00001)
and it worked for me. You can change the upper, lower and increment values to suit.
Here's the formula I was using (it was created by the What If tool in Power BI):
Util Target = GENERATESERIES(0, 1, 0.0001)
Thanks for the suggestion but still no luck.
I've also tried:
GENERATESERIES(0.00001, 20, .00001) GENERATESERIES(0.00001, 20, 0.00001) GENERATESERIES(0, 20, .00001)
If it has worked for you, it may be a problem with what I am trying to filter?
Could be. Check the format settings of both the Parameter calculated measure and the item you are filtering.
