Filter based on Column

[Anonymus_18]

I have a column with comma separated strings.I need to create a slicer for filter value that if I select any word I get all the rows having that word

For an example

Col1

Cricket,tennis

Cricket,football,tennis

Football,tennis, hockey

Hockey

Tennis,hockey

Cricket

Cricket,football

This is the column ,so if select cricket in a filter the matrix should show all the rows which have cricket

[Anonymous · Accepted solution]

Hi @Anonymus_18 ,

Please try below steps:

1. below is my test table

Table:

Table2:

2. create a measure with below dax formula

Measure =
VAR a =
    SELECTEDVALUE ( 'Table 2'[Column1] )
VAR b =
    SELECTEDVALUE ( 'Table'[Column1] )
VAR c =
    IF ( CONTAINSSTRING ( b, a ), 1 )
RETURN
    IF ( NOT ( HASONEVALUE ( 'Table 2'[Column1] ) ), 1, c )

3. add a matrix visual with Table fields and add measure to it filter pane and set

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymus_18 , two way, One is split column by delimiter, second to have a dimension with splitter value

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

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