Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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's avatar
    parry2k
    7 years ago

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

parry2k's avatar
parry2k
Super User
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.