how to attach url(link) to column values

[pankaj_2086]

hello everyone,

actually I am stuck with one task for a long time, I have one table in which there are some IDs of employees and I want to attach the link to those id's so that whenever I click on them I will get directed to that link in the browser.

I have already made a URL link using DAX.

PFB attachment for more information.

As we can see in the above image there is one column named Final URL with links buttons, I want those links to be attached to the Work Item Id column for eg if we click on 3829 the link should open in the browser.

Using DAX expression I have made url link as,

Final URL = CONCATENATE('Work Items - All history by month'[Intial URL]&'Work Items - All history by month'[Project Name]&"/"&"_Workitems"&"/"&"edit"&"/",'Work Items - All history by month'[Work Item Id]&"/")

[Anonymous · Accepted solution]

Please check this documentation

https://docs.microsoft.com/en-us/power-bi/power-bi-hyperlinks-in-tables

There is clear demo on your requirement.

Thanks
Pravin


If it resolves your problem mark it as a solution and give Kudos.

[Anonymous]

Is your problem resolved?

Don't hesitate to give Kudos and mark it as a solution.

[pankaj_2086]

actually it's in my office system so I will try to solve it tomorrow. I will get back to you if I get stuck anywhere

thank you, Praveen.

[v-chuncz-msft]

@pankaj_2086 

Any progress, feel free to share with us. By the way, you may help accept the solution above. Your contribution is highly appreciated.