Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
This is PowerBI file link for the download: https://drive.google.com/file/d/1fPKTdqY03QBblvolIjpbQzI8GfKI0moX/view?usp=sharing
Now my question is that i am working on the two table "Beam", "Column" Now i want to get the One slicer as "Beam", "Column" as Element and after if I select the "Beam" then in second slicer "It's Reference Level" column's distinct value and from that filter the beam table.
Same if in One Slicer I select the "Column" then in the Second Slicer shown distinct value of the Base level column of the Column table.
Note : In the Second Slicer the value is dynamic and use the Reference Column of the Beam table and Base Level column of the Column table.
Twist is that if in second slicer some value would be same in the Beam and Column table In "First Floor" Value of the second slicer means that if i filter the Beam in First slicer and First Floor in the second Slicer then it plot or filter the "Beam" table and not a Column tabel because i selected the "Beam" in the first slicer.
For the practical view in the snapshot below
Left one is the "Beam" table and Right one is the "Column" table
Solved! Go to Solution.
Hi @PIYUSHPRAJAPATI
Please find the PBIX file link and use same measure for your PBIX project
https://drive.google.com/file/d/1f-3D3x_mx0TWFzUXwyw5TDk0bw_qAfQR/view?usp=drive_link
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Hi @PIYUSHPRAJAPATI
Sorry, in the previous comment, I shared the wrong file.
Check the solution in the attached file
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Hi @PIYUSHPRAJAPATI
Please find the PBIX file link and use same measure for your PBIX project
https://drive.google.com/file/d/1f-3D3x_mx0TWFzUXwyw5TDk0bw_qAfQR/view?usp=drive_link
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Hi @PIYUSHPRAJAPATI
Sorry, in the previous comment, I shared the wrong file.
Check the solution in the attached file
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.