Create a URL Button bounded with a link from a filtered table

[IonSinch]

I want to create a button that will allow me to open a link. Using the slicer, I select the building and floor from the "Building" table. Each pair Building-Floor hat a corresponding URL in the "URL" table.  After the slicing, the button should open the link corresponding to the filtered floor and building.

Power Bi presentation: https://1drv.ms/u/s!AqTj4oBuroQ3rF4_ji1m0J1mTTNt?e=xwmpnN 

Excel file "Building": https://1drv.ms/x/s!AqTj4oBuroQ3rFxbWDThEZlf9LzN?e=Gw2QtH 

Excel file "URL": https://1drv.ms/x/s!AqTj4oBuroQ3rF3KQM8DI8axv-PW?e=1yHhAx 

Thank you in advance! 

[IonSinch · Accepted solution]

So I have found the solution. I will use a new column to combine Building + Floor and after that will give me unique values that I will be able to connect with my URL table. After that I will use this method: https://www.youtube.com/watch?v=m4a2c55eXMU to create a dynamic button.

[TomMartens]

Hey @IonSinch ,

I'm wondering why you need a button, and can't use the url column from inside the table?

From the selection in your pbix there are 2 links which one has to be linked to the button.

Nevertheless the screenshot belows, that you can use a measure that dynamically ties a link to the button. Without a clear business on how to treat multiple rows and multiple measures, wirting this measure will not be possible.

Hopefully, this provides some new ideas.

Regards,

Tom

[IonSinch]

Hey @TomMartens,

I cannot establish a Relationship between the "Building" and "URL" tables. I want to slice the "Building" table in the way that just a building and a given floor from this bulding should be selected. There is just one URL that correspond to a pair Building-Floor(it will be a link to the floor's plan). I do not know how to make that relationship. I try to make an interactive dashboard for a project and the user should have a clear way to access the plans, a Button is something very "easy".