How to add Hyper URL link of Different SharePoint sites to Power Bi table item??

[chintu9494]

I have a project sharepoint list that is collection of all different project sharepoint sites that i have. I have table in power bi with those project names, i want to be able to add the different project SharePoint site links as Hyperlink in Power BI dashboard so when I click on that Hyperlink it will open the project sharepoint site

Below given are sample URL of project sites, the one highlighted in blue text is the dynamic item that keeps changing

https://SharePoint Site/Project Name/Home.aspx

https://sharepoint.com/sites/Project_portal/pmo-mgdwrk-XpertDocProofofConcept/SitePages/Home.aspx

https://sharepoint.com/sites/Project_portal/pmo-mgdwrk-DocumentCentre/SitePages/Home.aspx

https://sharepoint.com/sites/Project_portal/pmo-prj-JSAngularUpgrade/SitePages/Home.aspx

The table in Power BI looks like this where when i click on project name it should open the above project sharepoint sites

Project Name

XpertDoc Proof of Concept

Document Center

JS Angular Upgrade

Thank you

Chintu

[vicky_]

First, you'll need to add another column to get the project site url part, such as:

Project Name	Dynamic URL Part
XpertDoc Proof of Concept	pmo-mgdwrk-XpertDocProofofConcept
Document Center	pmo-mgdwrk-DocumentCenter
JS Angular Upgrade	pmo-prj-JSAngularUpgrade

You can use a DAX formula to give you the correct link:

URL = "https://sharepoint.com/sites/Project_portal/" & SELECTEDVALUE(Table[Dynamic URL Part] & "/SitePages/Home.aspx"