Filter ( slicer ) to work on comma separated value

[Kartic21]

Hi ,

i have below table "HumanPets" which has value comma sepearted. I am trying to build a slicer where has unique value from LovesPets column  . ( cant split the coumn in power editor as data is huge but any thing with column creation and modeling will help )

Name	LovesPets	Comments
Sheldon	null
Amy	Dog
Penny	Bird,Dog,Cat
Howard	Cat,Turtle
Leonard	Dog,Cat

Now, i want to have a slicer (filter) with multi-select like distinct uniue values :

Pet:

• Dog
• Cat
• Bird
• Turtle
• Blank
  Once i select the value from above slicer it should filter the complete page with that value.
  For eg if i select Dog, it show give me 3 rows in for HumanPets table or if i select turtle it should give me 1 row or if i multi slect ( dog / turtle ) it should give me 4 rows.
  
  Thanks in advnace for the support .
  
  
  

[lbendlin · Accepted solution]

You need to prepare a disconnected table that lists all possible options separately. Then you can use ContainsString in your measure.