Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI - Dynamic link to external website with search function

Hi,

 

I have a table visual with some reference numbers (MAWB column below) that should allow users to click on each MAWB number with a hyperlink, and it will bring the users to an external airline website with the result of that particular MAWB number.

 

In the below example, there are 3 MAWB numbers in a table visual and I want to create a clickable URL link for each MAWB number with external link. When the users click on 105-59000675 that is operated by Finnair, Power BI will redirect users to Finnair's official website (which is an external link) with the search result of 105-59000675.

 

 

Does anybody know if this can be done in Power BI or not?

How to put that in place with DAX formulas given that I have the mapping list of airline code (first 3 digits of the MAWB: eg. 105 for Finnair) and all I want to do is to pass the MAWB numbers from Power BI to the airline's search engine in order to populate the correct result by just a single click from Power BI interface?

 

Thanks!

 

Best regards,

Emily

 

 

 

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak Thanks for the link.

      I think the proposed solution with custom URL is only for linkage to another Power BI report rather than external site.

      What if I want to pass the parameters from Power BI to external URL link such as airline search engines?

       

      Thanks.

       

      Best regards,

      Emily

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    According to my test, this is not feasible. Although we can use measure to dynamically change the URL parameters, we can't automatically fill in the number and search by changing the URL parameters.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.