Solved: dynamic URL to go to a specific web page

Anonymous · ‎07-15-2020

Hi all: Good day! I have a ‘More info’ button in a drill-trough detailed page which gets enabled when a notice_id is selected from a ‘Table’ visual . I have a measure with conditional formatting to use this measure to open a webpage on click of the button. The measure is as below:

Web Link Dynamic = "https://abc.com/xyzportal/notice/" & SELECTEDVALUE ( Table[notice_id] )

The notice_id is passed correctly to the detailed page and the url is built dynamically with the id like

https://abc.com/xyzportal/notice/29900244

I tried to open a new tab in the browser and tested the url- it takes me to the desired ‘Notice detail’ web page

But, as I control+click on the “More info” button [though it shows the right url as tooltip], it doesn’t go anywhere.

I am trying to mimic the behavior following the website that has a web page with a link for ‘notice detail’, clicking the link: IE opens another window to show the ‘notice detail’ page, on Chrome the first page changed to ‘notice detail’ page [no new tab/ window opens up].

I have IE as default browser.

Not sure why I can’t go to the website though the url is created OK. Could anyone help? Many thanks in advance. 🙂

Anonymous · ‎07-16-2020

Hi all: I just found that the issue was very simple- I somehow had a space after the " and before https in the url I had in the measure:

Web Link Dynamic = " https://abc.com/xyzportal/notice/" & SELECTEDVALUE ( Table[notice_id]), so deleting that space like below

Web Link Dynamic = "https://abc.com/xyzportal/notice/" & SELECTEDVALUE ( Table[notice_id]), I can contol+click the 'More info' button and go to the website to see the detailed notice info! 🙂

Best, ~Sohana

View solution in original post

parry2k · ‎07-15-2020

@Anonymous make sure data category for this column/measure is Web URL

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

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 · ‎07-15-2020

Hi @parry2k: thanks for your response. Since the 'More Info" button i created with Action-> Web Url and conditional formating to use the measure- it should work [it did work in a previous case for me with opening up a web page with a location_id being passed]. I made the category of the measure-> Web Url as u suggested! But, it didn't help! 😞

I am thinking anything else I am missing to open a new window/tab to bring that page?

Much appreciated in advance!

Anonymous · ‎07-16-2020

Hi all: I just found that the issue was very simple- I somehow had a space after the " and before https in the url I had in the measure:

Web Link Dynamic = " https://abc.com/xyzportal/notice/" & SELECTEDVALUE ( Table[notice_id]), so deleting that space like below

Web Link Dynamic = "https://abc.com/xyzportal/notice/" & SELECTEDVALUE ( Table[notice_id]), I can contol+click the 'More info' button and go to the website to see the detailed notice info! 🙂

Best, ~Sohana