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 be able to input one unique value, instead of a range of values or "greater than" / "lower than":

How can I achieve that? Already tryied to change the type of data of the column.

Need Help
Tips and Tricks

5 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, 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.

     

  • 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.