Multiple Slicer Question

[PIYUSHPRAJAPATI]

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

[PijushRoy · Accepted 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

[PijushRoy · Accepted 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

[PIYUSHPRAJAPATI]

Not Like that @PijushRoy 

[PijushRoy · Accepted solution]

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