Forum Discussion
Advocate IDisplay multi-select lookup items from a SharePoint List in a report?
Hi Class66Loco
If I understood you correctly you need to split the data into rows, to get a row for every selected item.
If this is the case please check my POWER query solution in the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/Pie-Chart-Separating-Values-in-Same-Row/m-p/3245643If it is something else,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Class66Loco
I'm not very familiar with Sharepoint lists, but if there's a way to import the hyperlink to the table you're pulling from, you can also display it as a hyperlink in the visuals and give the users option to drill to it.
take a look at the linked video :
https://www.youtube.com/watch?v=mxCAfHaqCxkIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Advocate IRitaf1983 thanks for your help. You've helped with splitting up the data by delimiter.
Ideally I'd like to be able to hyperlink each of the data (text) so they link to their respective SharePoint List items.
Thanks again.
- Ritaf1983
Super User
Hi Class66Loco
I'm not very familiar with Sharepoint lists, but if there's a way to import the hyperlink to the table you're pulling from, you can also display it as a hyperlink in the visuals and give the users option to drill to it.
take a look at the linked video :
https://www.youtube.com/watch?v=mxCAfHaqCxkIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- Class66Loco
Thanks again.
Yes there's hyperlinks being drawn through into the Power Query but they're very long and hidden amongst different text and numbers. I might have to discuss with my client.