Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering a slicer

Hello

 

I create a slicer but I want to permanently remove some of its entries. I created a Measure = FILTER(Table,[Col1]<>"something") but it does not work.

 

Any idea? It would also help to know why it didn't work.

 

Thanks!

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    A measure cannot return a table. You could write a measure like this

    SlicerFilter = IF ( "something" IN VALUES ( Table1[Col1] ), 0, 1 )

    and then add that measure to the filter pane of the slicer and set it so SlicerFilter is 1.

     

    The easier way would be to go to the slicer filter pane and select all options under Basic filtering and then uncheck the ones you don't want.

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    A measure cannot return a table. You could write a measure like this

    SlicerFilter = IF ( "something" IN VALUES ( Table1[Col1] ), 0, 1 )

    and then add that measure to the filter pane of the slicer and set it so SlicerFilter is 1.

     

    The easier way would be to go to the slicer filter pane and select all options under Basic filtering and then uncheck the ones you don't want.