cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AstKgn
New Member

Dynamic Web URL Link upon User Slicer Selection

Hi @ExpertBI ,

 

I am trying to have a dynamic button redirecting to a web link which varies upon the user slicer selection. Could you help? 

 

Many thanks,

 

Astrid.

1 ACCEPTED SOLUTION
Migasuke
Responsive Resident
Responsive Resident

Hi @AstKgn ,

There is one more thing, you need to set type in measures:

Migasuke_0-1629464577052.png

 

View solution in original post

4 REPLIES 4
AstKgn
New Member

Thanks for replying, Migasuke. This is still not working, here is what I am trying to do in more details:

 

I want the user to select either the "English" or "Mandarin" language, as shown below:
 
AstKgn_0-1629459782445.png

 

And then have a button that redirect the user to the correct web link, in English or Mandarin language. So I have affected a value to each language, "English"=1 and "Mandarin"=2 in my table with two columns. And then I have created this measure below:

 

URL = IF(Guidance_SEL[Value]=1), "XXXX.com","YYYY.com").

 

But this is still not working...

Migasuke
Responsive Resident
Responsive Resident

Hi @AstKgn ,

There is one more thing, you need to set type in measures:

Migasuke_0-1629464577052.png

 

View solution in original post

Hi @Migasuke, Brilliant it's working now thanks a lot!

Migasuke
Responsive Resident
Responsive Resident

Hi @AstKgn ,

This is quite simple to do.
1. Do a measure, which reflects your slicers and return you the URL.
Something like Measure = SelectedValue('Table'[WebUrlColumn])
2. Create a Button, where you select action for Web URL, go to fx options and select your created measure:

Migasuke_0-1629458601890.png



In case you would struggle, let me know.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Users online (1,282)