Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 is not working as it naturally would work when tables have relationship.
Look in the imabe below my table scheme:
- Slicer 1 is populated using table Project_List and column "Project Name"
- Slicer 2 should be populated with the column "Activity_Type_Description" from table "Activity_Type_List"
My entire chart is being drawn using data from the Project_Database and Project_Baseline tables, so when selecting the slicer 1, the second slicer would show DISTINCT values from "Activity Type Description" column from both tables Project_Database and Project_Baseline.
If I simple create two slicer and put the values from tables "Project_List" and "Activity_Type_List" is not working.
Is there a way to accomplish this?
Does anyone have an idea how to do it?
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
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.
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |