cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

2 ACCEPTED SOLUTIONS
parry2k
Super User
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. 






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

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






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
parry2k
Super User
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. 






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

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






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Anonymous
Not applicable

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!