Distinct values from cell as filter

[Anonymous]

Hi,

I have country column, where multiple values can appear in a cell.

Example, for row of column "Available Country", data appears in following way (data in a cell):

Is there a way in which I can take distinct values from this column and show it as a list using slicer,

in that case if I select "India" as a the value in the slicer all rous where India appears as a country should come up in the grid.

Regards

Tanmay

[Fowmy · Accepted solution]

@Anonymous 

You need to split the column into rows to create a distinct list in Power Query and add measure as follows then assign the measure to the visual filter of the table. Please check the attached file below my signature.

Selector = 
INT(
    CONTAINSSTRING(MAX(Master[Country Availability]),SELECTEDVALUE(Slicer[Country]))
)