Slicer with multiple options - how to filter disagg data

[parize2202]

Dear friends,

I have faced on issue on slicer for the field with multiple selection. On screenshot 1 you can see Slicer with Sections name and in one case it is C4D and Comms section together. What I want to have it slicer with the separate section names, i.e. selection from C4D, Comms move to their relevant fields. I tried to delimeter and unpivot, did not help in this case. Can you please help, since I feel helpless((  I tried to create another table with Section field, but slicer does not apply to the dashboard. Sync was adjusted. So, have no idea. 

[amitchandak · Accepted solution]

@parize2202 , I am assuming you have comma separated string and you want to filter both values when you select comma separated string

refer

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

[parize2202]

Perfect. Thanks a lot! Worked well