Slice by contents within a single cell?

[CBloome77]

Hi All, 

Not sure if this is something possible, but here goes:

I have a listing of events with multiple team members (generic demo below), and I'm wondering if there is a way to create a slicer that returns only those entries that contain a specific name.  IE, I'd like to click Jane Doe, and it'll slice it down to event A and B only.

Reciprocally, Is there any way to have a roster of names, and have it return all events/company/status that that name is part of the team column.  I can figure out some True/False columns, but that would be prohibitively long due to the size of the roster.  Not sure if this is something that can be done, but I thought it's worth a shot.

Thanks!

[KNP · Accepted solution]

Would something like the Text Search Slicer custom visual work for you?

It allows you to type to search, it does a 'contains' match and allows wildcards.