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.
Hello everyone,
I am struggling with an interesting puzzle.
Consider having a directory table with elements A, B, C, D, E.
The question is: can we somehow create three connected slicers with single selection each so that they could consider the selection of one another?
In other words:
I also note that the sequence of the slicers remains the same. So the second will be chosen only after the first, and the third - after the second.
Many thanks for your help in advance!
Solved! Go to Solution.
Thanks a lot for posting. That was a good one 🙂
the first table has the slicer choices in the first column, and the remaining choices in the second column
the second table has matching "remaining choices" in the first column, with one record for each remaining choice in the second column.
The relationship is between the remaining choices columns
when you select in the first slicer, the second slicer is filtered by the relationships to show only the individual remaining choices
You can extend this model my adding an additional "remaining choices" column to the second table, and then adding a third table based on those values
Help when you know. Ask when you don't!
Thanks a lot for posting. That was a good one 🙂
the first table has the slicer choices in the first column, and the remaining choices in the second column
the second table has matching "remaining choices" in the first column, with one record for each remaining choice in the second column.
The relationship is between the remaining choices columns
when you select in the first slicer, the second slicer is filtered by the relationships to show only the individual remaining choices
You can extend this model my adding an additional "remaining choices" column to the second table, and then adding a third table based on those values
Help when you know. Ask when you don't!
Wow, simple and elegant solution. Many thanks!
@Anonymous yes can be achieved but not straigh forward,
- you need 3 tables for 3 different slicers
- and then you create a measure based on the selection and use the visual level filter on other slicers to exclude the already selected values.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |