Custom URL Link in report that directs user to Azure DevOps work item using fields in table

[Anonymous]

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-de...

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

[v-kelly-msft]

Hi  @Anonymous ,

Check whether below link helps:

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

@v-kelly-msft ,

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 · Accepted solution]

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,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

@v-kelly-msft ,

Thank you that helped me get to the right solution.