How can I keep observations without specific value?

[Petersonne]

Hi, I'm trying to make a table, where the user can filter observations without a specific value. For example, let's say the user wants to focus on companies that does not produce apples and this is the dataset:

Company	Products
A	Apple
B	Apple, Banana
C	Banana

With a slicer I can choose companies that produce bananas, but that means company B and C remain in the table - I want to keep only C. 

I don't want to give users access to all the filters. And since I have 30 "products" I hope to avoid create dummies for Apple, Banana, .... Is there a smarter way?

[Petersonne]

Thank you Greg, that is exactly what I was looking for. I've been looking for that quite some time!

[Greg_Deckler · Accepted solution]

@Petersonne So you want an Inverse Selector then? 

Inverse Selector - Microsoft Power BI Community