Forum Discussion
Helper IParsing out multiple values in a single column
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!
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
2 Replies
- amitchandak
Super User
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
jdriscollThank you very much for the help!