Slicer that returns distinct values of delimited string

[caseycook]

I'm looking for a way to return the unique values of a column that contains a delimited string into a slicer.  Then when a value is selected in the slicer it will filter the dataset to rows that contain that value.

[Tkiesnowski]

How do you set this up but on a larger scale? Entering in the data manually is easy with just three entries, but what if you have a massive data set?

[v-chuncz-msft · Accepted solution]

@caseycook,

You may split column by delimiter through Query Editor. See attached file for more details.