Slicer displays all results matching

[annetoal]

A data file has been run through a noun recognizer. I would like to make a slicer of the results, and when a word is selected, have all the instances of the word show up in a table.

Here is the data:

ID	Response
10101	I wish I had a bicycle
20100	The man with the bicycle is very mean
30587	I liked it when the cat did a dance
103543	Everyone should have a bicycle
212032	No comment, everything is fine
23765	The cost of gasoline is too high
223588	I don’t know how to drive
342231	All residents should be required to pass a bicycle riding test

The keyword table looks like

ID	Response
10101	bicycle
20100	bicycle
30587	cat
103543	bicycle
212032	everything
23765	gasoline
223588	I
342231	bicycle

The slicer needs to show:

bicycle

cat

everything

gasoline

I

When you click a term, a table should show all the instances of that keyword. For example, if you click "bicycle," a table should show

I wish I had a bicycle

The man with the bicycle is very mean

Everyone should have a bicycle

All residents should be required to pass a bicycle riding test

Could you please show me how to do this? Any assistance gratefully received.

Thank you

Anne

[Greg_Deckler · Accepted solution]

@annetoal I built this out, you want Table (12) and Table (12a), Page 12 of the PBIX attached below sig.

[annetoal]

Wow, that works perfectly. Thank you so very much. It's appreciated.

Anne