Forum Discussion
Select a unique value in slicer
I've created a table with numbers ranging from 0 to 9999 with GENERATESERIES function. The column with the values were formatted as integer number. When I use this column in a slicer, I want to b...
I think what-if parameter will suit more to your requirements
v-alq-msft
Community Support
Community SupportHi, Anonymous
Based on your description, I created data to reproduce your scenario.
Table:
Table = GENERATESERIES(0,100)
You may click 'more options' to change the slicer type. I'd like to suggest you use 'list' or 'drop down', which you can select one value to filter the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.