Fill value in URL and open

[Anonymous]

Hello everyone,

I want to realize something in Power BI and I do not know if it's possible. It's doable in Excel, but may be a little advanced for Power BI.

So, I have a column with data like this (example):
T1111
T2222

T3333

T4444

The values are a ticket number in another system. In the system the links are https://example.com/ticketlookup=T1111 (etc.).

Is it possible to have the link https://example.com/ticketlookup= in Power BI, and that the ticketnumbers get filled in the URL from the column? So when I click on one of the ticketnumbers in a table or matrix, the correct link in my ticket sytem will open?

Let me know if you have any questions.

Thank you for your taken time and effort.

Best regards,

AliBI

[parry2k · Accepted solution]

@Anonymous add new column in your table and on modelling tab change its category to web url

Ticket Url = "https://example.com/ticketlookup=" & Table[TicketNumberField]

Now when you drop this url in table visual, you will able to click and open the ticket. 

[parry2k · Accepted solution]

@Anonymous add new column in your table and on modelling tab change its category to web url

Ticket Url = "https://example.com/ticketlookup=" & Table[TicketNumberField]

Now when you drop this url in table visual, you will able to click and open the ticket. 

[parry2k · Accepted solution]

@Anonymous also in format tab, you can turn on "url icon" under value, it will show small icon instead of full url.

[Anonymous]

@parry2k Wow, what a simple and great solution. Thank you very much, both for the solution and the tip to display an URL icon instead of a long link! It works perfectly.