Creating a "Contains" Slicer for Multi-Value Column in report page

[dkao]

Hi all,

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

1	A, C
2	A, B, C
3	A, D

And my 'UserGroup' table:

User Group

A

B

C

D

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.

Thank you!

[amitchandak · Accepted solution]

@dkao , refer to this approach

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

[Thomas_td]

Great explanation, exactly what I was looking for. Thanks!