Create advanced Slicer

Hi Anonymous,

Current you can't directly use the default slicer feature to achieve your requirement.

I'd like to suggest you create a new table to expand these concatenate location values to single location list.

New Table =
VAR _path =
    SUBSTITUTE ( VALUES ( 'Table'[Column] ), ";", "|" )
VAR _length =
    PATHLENGTH ( _path )
VAR _pathtable =
    ADDCOLUMNS (
        GENERATESERIES ( 1, _length, 1 ),
        "Location", PATHITEM ( _path, [Value] )
    )
RETURN
    pathtable

Then you can use new table fields as source of slicer and write a measure formula to extract the current location to lookup table records and return tag. 

SEARCH function (DAX) - DAX | Microsoft Learn

Applying a measure filter in Power BI - SQLBI

After these steps, you can use this formula on the 'visual level filter' to filter table records.

Regards,

Xiaoxin Sheng