Dynamic Slicer, multi values

[wes11]

Hello!  I have a table that contains a column with multiple values (comma delimited).  I would like to create a dynamic slicer that displays the unique values of this column and display the rows that contain the unique value(s).  Any insight on the best way to accomplish this?

Desired results: Single slicer value, when selected by user filters rows that contain that allergen.

Thank you!

[wes11]

Thanks for the link and response!  Appreciate it @amitchandak!

[amitchandak · Accepted solution]

@wes11 , better you split the table using the split column to rows, or create a table from this column in power query and split that

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/