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


     

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