Forum Discussion
Solved
To create a filter using comma separated field.
Hi, I need to pull data from a field (with comma separated values). This field continue to have new values added when new incidents are recorded into the DP table. I need it to be uniquely shown in ...
Jayprekk , I have made one attempt in the past as discussed in the blog
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
Hii Jayprekk
Power BI cannot filter comma-separated values directly, so the correct solution is to split the tags into rows. In Power Query, use Split Column >> By Delimiter >> Comma >> Split into Rows to normalize the Security Tags field. This creates a proper one-tag-per-row table that you can use as a slicer. When the user selects “Bus,” Power BI will correctly return records like 1111 and 2222 because they now have a real relational match instead of text search.
Thank you for the help. Much appreciated