Forum Discussion

stackover's avatar
stackover
Frequent Visitor
2 years ago

Create a dependent slicer on another slicer selection

Hi all. How are you doing? I need help creating a second slicer and populating it with values based on another slicer selection. As the tables doesnt have direct relationship to each other, this i...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi stackover 

Please find the post for your reference
https://community.fabric.microsoft.com/t5/Desktop/Hierarchy-Slicer/td-p/1888196

 

Use ISFILTER DAX https://learn.microsoft.com/en-us/dax/isfiltered-function-dax

 

Means, if 1st level slicer is filter, 2nd level will show based on 1st level selected
PBIX file for your reference
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 mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

stackover's avatar
stackover
Frequent Visitor
2 years ago

Thank for your answer, but it is not what I am looking for. Read my description and my relationship diagram and will see that there are lots of different details from your proposed solution.