Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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"