Forum Discussion

andrewwglenn's avatar
andrewwglenn
Helper I
6 years ago

What If Parameters

I am trying to test the What If functionality and noticed that I am unable to enter in specific values into the selection tool.

 

For example:

If I want to use "production volume" as a What If parameter in the following fashion: param = GENERATESERIES(0, 10000, 1), Power BI limits my ability to assign any integer via this selection tool. It forces me to enter in values in increments of 10.

 

Is there a way to allow for specific values to be entered?

 

Thanks.

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    That doesn't seem correct. Try changing the slicer to a list and see what is listed. Are you sure you chose an increment of 1 and not 10?

     

    • andrewwglenn's avatar
      andrewwglenn
      Helper I
      6 years ago

      I'm not sure how to link my file, but here's a screen shot of what it looks like.

      When I adjust "Select QTY" on the left, it forces me to do so in increments of 10.

      For reference, ASP = GENERATESERIES(0, 10, 0.01), and this works as intended.

       

      calc_m = val * ASP

      calc_m_q = calc_m * QTY

       

      Also, I found this: https://community.powerbi.com/t5/Desktop/What-If-Parameter-Issue/td-p/313047

      It seems perhaps the What If parameter is limited to ~1000 selections within the range.

      I am not sure if this remains true, but thought I'd share.