Forum Discussion
Fill value in URL and open
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
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.
Anonymous also in format tab, you can turn on "url icon" under value, it will show small icon instead of full url.
3 Replies
- parry2k
Super User
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.