Forum Discussion
Create a URL Button bounded with a link from a filtered table
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!
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.
3 Replies
- TomMartens
Super User
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
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".
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.
