Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Connected slicers (exclude earlier selected values)

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...
  • kentyler's avatar
    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