Display 'Related Items' as link within PowerBI Report

[Shelley-Baynton]

Hello,

Looking for some assistance and couldn't find what I'm looking for searching the internet.

We've been asked to put together a 'Issues Log Report' and be able to drill down into the details in particular accessing the 'Related Items' and seeing that information. The SharePoint list has the 'Related Items' column i.e. lookup column but I'm unsure how to generated the 'Report' on PowerBi.

I'm assuming I'd have to format the 'Related Items' column to extend the options selected but I don't know how I'd format it so the hyperlink would work in the report. 

How would we achieve this on PowerBI? 

Thanks in advance 😁

[josef78 · Accepted solution]

Yes, if you have some table with URL link (or any other values from which you are able construct URL link), you can load to report (and if you want, you can relate to detail data in report).

Then you can add classic Table and add some column (you can use some another value for link label), and in Conditional formating section, select rigth column when you can show, enable Web URL link format, and then select column contains URL link.

[v-cazheng-msft · Accepted solution]

Hi, @Shelley-Baynton 

You can try the following steps.

1 Create a Measure (Measure can save your Memory)

format_url =

SWITCH (

    SELECTEDVALUE ( items[item] ),

    "A", "https://docs.microsoft.com/en-us/dax/switch-function-dax",

    "B","https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting"

)

2 Conditional format ‘item’ column

The result looks like this:

When clicking the item, related link will be opened in browser.

Here is the sample.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Generally you have two options

1. Include the list column and let Power Query do the lookup.  This is SLOOOOOW.  Might work with short lists and few related items

2. Import the list, and also import the related list.  Use the data model to link them together.

3. (Bonus option) Use the ODATA connection to sharepoint to hand craft a query that returns everything you need in a flat table.

[josef78 · Accepted solution]

Yes, if you have some table with URL link (or any other values from which you are able construct URL link), you can load to report (and if you want, you can relate to detail data in report).

Then you can add classic Table and add some column (you can use some another value for link label), and in Conditional formating section, select rigth column when you can show, enable Web URL link format, and then select column contains URL link.