Adding dynamic URL to go to a specific web page

[Anonymous]

Q: Good day everyone! I have a Map and added a Drill-through feature to show some info for a particular bubble I click on the map. There is a website that already shows a lot of detailed info that I want to use in my Drill-through page. One option is to create all those info in this page or second option that I am trying to create is to add a “More info” visual by clicking that I want to go to that detailed page web page!

There is a ‘location_id’ field that dictates which is the destination to go for that particular bubble/ location. The url will be something like:  http://abc.com/ABCD/#/app/location/210245, where the last field is the location_id which will change.

 There are a lot of location_ids in the data base View I am using as the data source. So, using a table with manually adding all the URLs and using it in the ‘More info’ is not a realistic option. How can I dynamically add the location_id in the url part to go to when I click on ‘More Info’? Any help will be greatly appreciated!  

[parry2k]

@Anonymous I guess more info button gets enabled when a location is selected, you can create a measure and then use conditional formatting to use this measure to open a webpage on click of the button.

Web Link Dynamic = "http://abc.com/" & SELECTEDVALUE ( Table[Locaion_id] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Hi @parry2k thanks a lot for your response. The button and measure now adds the location id at the end of the url! But I still have an issue.

The website I am trying to go has a login page, then it takes me to a "Map" [https://abc.com/xyz/#/app] where I can click on a location, brings a info box with a "More Info" tab, clicking that takes me to the detailed info page[https://abc.com/xyz/#/app/location/406549]- my desired destination from my dashboard clicking on the 'More info' button!

What's happening is that after i click the button & I enter the login info, it takes me to the Map page rather than directly to the detailed info page, even though the url has all the info[location/location id] at the end] like https://abc.com/xyz/#/app/location/406549

I tried to open a new tab and used this complete path for the url, but same thing happens! it takes me to the Map page rather than the detailed info page!

Not sure what to do! Thanks. 

[parry2k]

@Anonymous I guess opening the web page and if that requires login credentials, and doesn't allow to pass that as a key, not sure what else to tell. You probably have to find out from the web service company to see if there is a way to pass some API Key and pass-thru the login page.

[Anonymous]

Hi @parry2k is there a way in Power BI to pass login credentials while I am specifying the url in the measure? I found another url to use that will open a new tab for the detailed page once I can pass thru login. Thanks.