Forum Discussion
How to add SharePoint link as hyperlink to column
I have a requirement to add hyperlink in one of my column called projectname.
Secenario is like this, My dataset is SharePointand it contains the list of projects created by client.
When client filter any visual from dashboard and when he click on any project name, he want to redirect to that row in sharepoint for making any changes for that
7 Replies
Hi shyamily_123
You need to prepare the URLs of those projects in a table column in advance. Then add this URL column to a table or a matrix in the report. Select the URL column, on the Column tools tab, select Data category > Web URL. You can refer to the following article to get detailed guidance.
Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hi,I need a dynamic solution because here daily new projects are being added. So it's not possible to add link for each project name.
My requirement is when i click on a project name it should redirect to that exact row in SharePoint.
Above solution is useful when i want to open that sharepoint list. Here that's not the case, i want to open that sharepoint site and the row that i clicked on power bi table visual.
Hi shyamily_123
Are these projects in the same sharepoint site? Do they have a similar URL format? If they do, you can add a column to get the dynamic URLs by concatenating the basic URL section and project name column. For exmaple,
URL column = "https://xxxxxxbasicURLxxx/" & 'TableName'[Project Name]Best regards,
Jing
