How Do I extract the keywords in this table? and create a slicer for it?

[benzeming88]

Hi Guys,

I have a set of data as per screenshot (pic 1) . There are many keywords generated by my system.

However, I want certain keywords example "Est Msa" and then filter them out by a slicer (example pic 2) by one of the past entry. but still i cannot figure out. Can someone please help.?

Thank you.

[V-lianl-msft · Accepted solution]

Hi @benzeming88 ,

Make sure the slicer is a field in a independent table.

You could create a measure like below and drag the measure to visual level filter.

Measure = IF(ISFILTERED('Table'[Column1]),IF(SEARCH(SELECTEDVALUE('Table'[Column1]),MAX('Table (2)'[Col]),1,0)>0,1))

It should be noted that multiple selection is not allowed because of the principle of selectedvalue.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer :https://community.powerbi.com/t5/Desktop/How-to-split-the-the-Column-into-Multiple-rows/td-p/253361

https://www.youtube.com/watch?v=0roS4OVfD9k

[Greg_Deckler]

Not 100% on wha you are looking for here. You could split out your FrequentNotes column in Power Query by semi-colon and then unpivot those columns. 

Or, just use an Enter Data query to enter in the keywords that you want.