Forum Discussion
Connected slicers (exclude earlier selected values)
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
Solution SageThanks 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
Wow, simple and elegant solution. Many thanks!