How to create a slicer that filters information if field contains specific values?

Question

I have a column that contains text like the following:

Name    Type 
Mark    FT
Jess    FT; #PT
Hallon  PT
Len     FT; #PT; #HT
Tessa   PT; #HT

What I'm trying to do is create a slicer that has ONLY three options: FT, PT, HT So if I choose FT, the following result would show:

Name    Type 
Mark    FT
Jess    FT; #PT
Len     FT; #PT; #HT

Answer 1

How to achieve this? Go to your Table, Then go to Edit queries

Then right click on Colum and duplicate it

Now right click on duplicate colum and click on split column by delimiter

Then below changes

You get something like below

Then Trim the same column

Then Replace Value

You get final Table

Go to Visualtization screen and add your column and new column and slicer you will get desired result