The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |