Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Please use Single Select option under Selection Control to restrict user to select one value and use dropdown or list from more option (... three dots on slicer) to use values instead of range.

Please find attached for the solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous and v-alq-msft , thank you for your reply!

    What I want is to be able to input the value directly in a textbox, but not in "greater than" or "between" mode.
    I've already seen this option on this tree dots dropdown menu, but for some reason it's not showing up here for me.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Worked like a charm!

         

        When the parameter is used with a slicer, the option to input a unique value becomes available.

        Thank you!