Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-directlinks?view=azure-devops&tabs=powerbi

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-directlinks?view=azure-devops&tabs=powerbi

4 Replies