Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |