slicer from a column with comma separated value

[sanjanarama]

number	customer name	hierachy code	url	engagement
100	aws	global customer	amazon.com	sales pipeline, regular
1002	amazon webservice	global customer	aws.amazon.com	sales pipeline
1003	wholes food market		www	complicated, sales pipeline
1004	aws	global customer	amazon.com	amazon

I have the above data, and I would like to have slicer for column "engagement". if "sales pipeline" is selected then first three rows are displayed,  is that possib;e to do

[amitchandak]

@sanjanarama , Not very clear to me. But Split column by delimiter into rows in power query can help

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[sanjanarama]

@amitchandak 

https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/m-p/407949

this post totally satisfy my requirement. But if I replicate same to matrix , it is not getting filtered,

[sanjanarama · Accepted solution]

to all if anyone wants to try, add the measure to filter panel and set to 1 . it works like charm

[sanjanarama]

if I have a slicer on customer engagement , i see that all values in it are combined. I want to show slicer values as each of the catergory, without splitting up the data with delimitter, as all other column data are same.