Forum Discussion

mkurup12's avatar
mkurup12
Icon for Helper I rankHelper I
4 years ago

User input (numbers) Power BI

I know you can use the what if parameter to get user input but that only works for 0 to 1000. Is there a way to get larger numbers into the input area? (I need it to be in intervals of 1).

I also don't want it to be a scrolling slicer. I like the way the what if parameter slicer works, i just need it to be able to handle larger number inputs.

 

Thank you

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    1000 values is a hard limit. You can either have an upper limit over 1000 or an interval of 1, but not both.

     

    Change your interval to 5 - that gets you from 0 to 5000 etc.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mkurup12 ,

     

    After my test, the maximum value of what-if parameter can exceed 1000.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Anonymous Sure, but you cannot move the slicer in 1 step increments any more.