Forum Discussion
Anonymous
8 years agoNot applicable
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. ...
- 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
Anonymous
8 years agoNot applicable
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?
Phil_Seamark
8 years agoMicrosoft Employee
Could be. Check the format settings of both the Parameter calculated measure and the item you are filtering.