Filtering a slicer

[Anonymous]

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!

[AlexisOlson · Accepted solution]

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.