I'm seeking help with creating a slicer that filters my data based on a "Contains" functionality rather than an exact match. I have two tables: 'User' and 'UserGroup', which are related via a one-to-many relationship. The 'User' table has a column called 'User Group', which may contain multiple groups concatenated by ', ' (comma and space) in a single cell for each user. The 'UserGroup' table has a single column, also called 'User Group', containing unique user group names.
Here's a sample of my 'User' table:
UserID User Group
And my 'UserGroup' table:
What I want to achieve is when I select a value in the slicer (created from the 'UserGroup' table), it should display rows in the 'User' table where the 'User Group' column contains the selected text. For example, if I select "C" in the slicer, the 'User' table should return rows with UserIDs 1 and 2.
I've tried several approaches, but I haven't successfully implemented the "Contains" functionality for my slicer. Can anyone guide how to achieve this? Any help would be greatly appreciated.