Forum Discussion
What If Parameter Issue
I've got 2 What if Parameters with formulas "Expense What If = GENERATESERIES(0, 300000, 1)" and "Budget What If = GENERATESERIES(0, 300000, 1)" When I put the "What If Parameter" to "Single Val...
Use a combination of UNION() and GENERATESERIES() such as the following, enabling scale within your What If Parameter, as well as enabling Power BI to manage the number of parameters it has to hold in memory.:
UNION(
GENERATESERIES(0,500,10)
,GENERATESERIES(1000,10000,1000)
,GENERATESERIES(20000,100000,20000))
I don't think the issue is getting the values in the table, it's the slicer won't take more than ~1,000 values when it's looking at a parameter.
A workaround may be to do what you were doing by unioning a few different GENERATESERIES() functions to give granularity and further detail in the important ranges.