Filter ( slicer ) to work on comma separated value

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 )

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 .