Forum Discussion
What If Parameter - Doesn't Have All Values
Super UserHi 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
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 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