Forum Discussion
Solved
Multi-Value SharePoint Fields
Hi Community.
I have a share point list with two coloumns that have multiple values.
Example
| College | Major |
| NJIT; NYU; DPS | Chem;Bio |
| FSU; UCLA | Chem;Bio;CS |
When I bring this data in Power BI, each cell contains “List Value”
| College | Major |
| List Value | List Value |
| List Value | List Value |
How do I bring the correct field values splitted in rows.
My Coloumn doesn't give options “Expand to New Rows” or “Extract Value”.
Please help I am new to Power BI.
Thanks,
Rana
itahir04 , You have to try split by Delimiter Twice(once for each column), and then you might to use remove duplicate in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
1 Reply
itahir04 , You have to try split by Delimiter Twice(once for each column), and then you might to use remove duplicate in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag