Forum Discussion
Connected slicers (exclude earlier selected values)
- 6 years ago
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
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.⚡