Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Distinct values from cell as filter

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

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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]))
)


     

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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]))
)