Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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.                 ...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Could be.  Check the format settings of both the Parameter calculated measure and the item you are filtering.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I've tried using the slicer in its own page but here's what I get when I enter:

    0.9866

     

     

     

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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/231d24e80fb1449d8ee00df4cb7d4b19