Forum Discussion
Custom URL Link in report that directs user to Azure DevOps work item using fields in table
hello,
I'm trying to create a custom column that would essentially be a URL Link that allows the user to click on it and open the specific work item in Azure DevOps. The URL would have some static information that would be the same acroos the board but would be using the specific fields in the table like Project.Name and Work Item ID to build out the URL Link.
For example: if the URL is https://dev.azure.com/organization/{Project.Name}/_workitems/edit/{Work.Item.ID}
the only thing unique for each of the work items would be the Project.Name and Work.Item.ID that would be pulled from a different column in that same row for the record.
Attempted to follow the following articles but didn't get far. Still new to Power BI.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-custom-column
Hi Anonymous ,
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/How-to-add-a-dynamic-URL-to-a-table/td-p/957035
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
4 Replies
- v-kelly-msft
Community Support
Hi Anonymous ,
Check whether below link helps:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- AnonymousNot applicable
No unfortunately this does not solve the question I had. I guess I needed to be a little more clear.
I am looking to create a custom column that will have a current URL but reference varlous columns/values within the same record.
For example:
Record.Name Project.Name Work.Item.ID Custom Column containing the Custom URL (//dev.azure.com/organization/{Project.Name}/_workitems/edit/{Work.Item.ID}) Example1 ProjectABC ID123 (//dev.azure.com/organization/{ProjectABC}/_workitems/edit/{ID123}) Example2 ProjectDEF ID456 (//dev.azure.com/organization/{ProjectDEF}/_workitems/edit/{ID456}) - v-kelly-msft
Community Support
Hi Anonymous ,
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/How-to-add-a-dynamic-URL-to-a-table/td-p/957035
Best Regards,
KellyDid I answer your question? Mark my post as a solution!