Forum Discussion
AdministratorCustom multi-location slicers
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.
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
2 Replies
- amitchandak
Super User
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
- v-easonf-msft
Community Support
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
