Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@Anonymous also in format tab, you can turn on "url icon" under value, it will show small icon instead of full url.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@Anonymous also in format tab, you can turn on "url icon" under value, it will show small icon instead of full url.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |