Forum Discussion
Solved
GENERATESERIES() Excluding certain values
All, I created a parameter table using the GENERATESERIES function as such: GENERATESERIES(-1, 1.0001, 0.0001) I use these values in a single value slicer to add a difference to a number. How...
Your parameter can have a maximum of 1000 discrete values. Your step resolution is too fine, resulting in sampling.
Is there a way to get a parameter table without that resolution issue? I tried to hardcode values from an excel but then you lose the ability to create a single value slicer.
No, there is not. And think about it from an end user perspective. No user will want to scroll through 10000 values.
If you want to allow the user to enter their own values use the Filter Pane.