What If Parameter - Doesn't Have All Values

[Ristaul]

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!

[MFelix]

Hi @Ristaul ,

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

[Ristaul]

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]

Hi @Ristaul ,

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