Forum Discussion
Advocate IDisplay multi-select lookup items from a SharePoint List in a report?
Hello,
- SharePoint List with muti-select lookup column.
- Power BI table visual.
Is it possible to have a table or matrix visual which displays multi-selected items separately and where user can click on one of the items and it opens up/expands to a screen/visual containing greater granual detail?
So it'd have one row of data and that lookup column would somehow display however many items were selected separately and these would be 'clickable' so it provided greater detail.
Thanks for any advice or ideas.
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.
4 Replies
- Ritaf1983
Super User
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.
Class66LocoRitaf1983 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
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.