"what if" parameter - turn off sampling so all numbers are generated in a range

[mark_cunningham]

Currently the what if parameter filter cant handle too many items. I am trying to create a filter for a range of all values between 1 - 100,000 but it keeps sampling the range. Need way to over ride the sampling

[ahines]

I agree that the limit needs to be increased. It is very frustrating to get a "Representative Sample" when I want it to be a single value. https://protect-us.mimecast.com/s/sIwrCyPMExFyk8VIAzyce?domain=community.powerbi.com

[jwenzlick24]

Needs to be fixed - feature is severely limited right now. How did this not get noticed before being released?

[mkeiper1]

Vote here also y'all. Hopefully one of these ideas takes off and gets popular https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32797822-what-if-parameter-slicer-limitations

[ltaylor23]

Agreed, the actual number appears in the generated table so we should be able to use that number

[dennwa]

Unbelievable that this is not fixed

[cortana1]

We need this to be fixed

[ndevries1]

Has my vote. would really make numeric what-if parameters more powerful and less confusing for end users.

[daniel_stark]

How is this not fixed yet? I create reports that require precise what if parameters over a wide range, so what else am I supposed to do?

[lee_richardson]

Agreed! This makes the value of input fields limited..

I am trying to create a "calculator" to allow input values to calculate margins, sell prices, etc for use by 800+ sales reps across the U.S. prior to sales.

Imagine that they are continually frustrated and confused that the value they input for a field is changed to some number that is not what they entered.

As a workaround, I have created an additional column that is formatted as a text version of the number value of the parameter to allow search and selection of any value in the parameter range.

However, this is not ideal. This workaround requires additional clicks and makes the interface clumsy.

Please resolve!!!

If this sampling feature is by design, I suppose it would have a use case somewhere.. although not sure what it is or who would find value in it this way.

Assuming that it is helpful to some, a solution might be to provide an option to turn sampling on and off as an additional add to the what if parameter configurations.

[joao_vitor1]

Please! This limitation is so insanely stupid!