Custom multi-location slicers

[Syndicate_Admin]

Good afternoon,

I have the following problem, in one column I have the cities that have assigned the staff, there are staff that have only 1 as there are others that have 19 cities, they all register me in the same column.

I need to create a visual of data segmentation in which only the cities register me, and then when I click on any of them it throws me the information of how many people there are for that city.

Thank you very much in advance.

[v-easonf-msft · Accepted solution]

Hi, @Syndicate_Admin 

Please check if formula below could help:

Count =
VAR _count =
    CALCULATE (
        COUNT ( Table1[Data.Tags] ),
        CONTAINSSTRING ( Table1[Data.Tags], MAX ( Table2[CD] ) )
    )
RETURN
    IF ( ISFILTERED ( Table2[CD] ), _count, COUNT ( Table1[Data.Tags] ) )

If it doesn't work, please share more details.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Syndicate_Admin , In power query remove [ , ] and double quote.

The option is to split the column into rows 

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

or you split it into a separate table

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c