Forum Discussion

Petersonne's avatar
Petersonne
New Member
4 years ago
Solved

How can I keep observations without specific value?

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:

 

CompanyProducts
AApple
BApple, Banana
CBanana

 

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?