Parsing out multiple values in a single column

[jdriscoll]

Hi,

I have a column coming in from a report that can contain any number of values from an option set, and I'd like to somehow parse it out so that I can use a slicer in my own BI report that recreates the option set. For example, the column is coming in similar to the screenshot below, and I'd like to have a slicer in my BI that would have System A, System B, System C, and System D as the possible values. What is the best way of achieving this?

Thanks!

[amitchandak · Accepted solution]

@jdriscoll ,

Refer the file attached after signature. Steps :

Create a table with this column in power Query - https://www.youtube.com/watch?v=kU2M1LmNvNo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=2

Then duplicate this column in new table and then split by delimiter into rows

Power Query Split Column, Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

In the model, view join this table with your original table , many to many join, filter direction from new table to your table

[jdriscoll]

Thank you very much for the help!