Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

What If Parameter - Doesn't Have All Values

I am trying to use the what-if parameter to help build a flexible calculator, the problem is that the options seem to be too rigid, and even when I use what Power BI allows, it doesn't work -

 

First issue - 

I can't have small incraments w/ larger numbers (first image below) - Well this stinks... ok let me try to increase the incrament to 10 (this seems to work; see image 2).... wait, now when it's added as a slicer, I can't even get down to that level of details (see 3rd image).... This gets worse the larger the max value, and I have a need to go multple millions as a max value. Please help!

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi Anonymous ,

     

    Regarding the first part of your question you can make a quick turn around if you look at the code it's generated when you create a parameter table you see its a GENERATESERIES formula so you can change the values so simply create the parameter table with minimum values and go to the code and place it like this.

     

    Parameter = GENERATESERIES(1; 100000; 1)

    Concerning the second part about the slider the issue is presented on the slider with an i on top

     

    Try messing around with the type of slicer you have to a list dropdown, et, maybe can work.

     

    Regards,

    MFelix

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi MFelix  - I tried the dax expression the same as you did. When looking at the data view, it works, it creates a single column table w/ the range and desired increment, but that is where it ends. The slicer still won't give all of the values.

       

       

      As for your second comment, I tried that too. You can select a dropdown or list that will display all of the values, but the UX stinks; since these are numerical values, PowerBI doesn't support search on those formats (strings only); so I can't have someone scrolling to get to 1 million plus (The use case is that this is to be an incentive comp calculator, and need both incentive comp and sales quota as parameters so really big values)...

       

      Thoughts?

       

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        7 years ago

        Hi Anonymous ,

         

        Try posting on the specifi issues part of the cummunity. Maybe you get a better answer, believe that taking into account that they have a warning on the slicer it design based,so no issue itself but maybe they have another option.

         

        Regards,

        MFelix