Connected slicers (exclude earlier selected values)

[Anonymous]

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: 

• If I select, for instance, B in the first slicer, the second slicer should have only A, C, D, E elements left for selection.
• If I select then, for instance, D in the second slicer, the third should have only A, C, E elements left for selection. 

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!

[kentyler · Accepted 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

[Anonymous]

Wow, simple and elegant solution. Many thanks!

[parry2k]

@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.⚡