Forum Discussion

ahines's avatar
ahines
Advocate IV
8 years ago

What If Parameter Issue

I've got 2 What if Parameters  with formulas "Expense What If = GENERATESERIES(0, 300000, 1)" and "Budget What If = GENERATESERIES(0, 300000, 1)"   When I put the "What If Parameter" to "Single Val...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI ahines

 

I thnk the idea is the table generated by the "What If Parameter" is to be used in a slicer.  This will then allow you to pick an individual value from your list of 1 to 300,000.  

 

It's the individual value that you can incorporate into your other measures.  This way, when you adjust the slicer using your what if measure table, any other measure that references the 'single' measure will recalculate and show the updated value.

parry2k's avatar
parry2k
Super User
8 years ago

Phil_Seamark i think the issue ahines mentioned is that user cannot enter single value in the box and I tried it by myselft and if I enter some number, it round off to next number. I think that is the issue ahines is trying to explain and totally agree with him

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI parry2k

     

    Oh yeah, it seems the slicer can't cope with that number of rows. 

     

    looks like values GENERATESERIES(1, 99998,1) might work or GENERATESERIES (1,300000,3)

     

    Seems to be based on the number or rows.....

    • ahines's avatar
      ahines
      Advocate IV
      8 years ago

      Thanks for the responses. None of the above proposed solutions are working. It still is picking a relative value to whatever "single value" I select. I'm not sure why Power Bi put limits on this.