slicer - how to return records that have all slicer options selected?

[Dervos]

Dear Experts,

I am wondering if there is a way to set up a Slicer to return records ONLY if they have ALL slicer options selected? For example - I don't want to see records that have slicer options 1 OR 2 OR 3 etc. but records that have slicer options 1 AND 2 AND 3 etc. ?

Case Scenario:

Using Slicer, I have selected:

• Skillset - Coaching + Mentoring
• Score - 4

Records returned are for Coaching, Mentoring and combination of both.



What I am seeking to get is below - a combination of Coaching + Mentoring with a Score of 4.



Is that even possible?

Appreciate your help!
D

 

[John_w]

I think just changing the If statement which decides whether a row should be hidden, so it ignores the 2nd slicer (the Score) values, because the autofiltering has taken care of that column, should give the desired result:

                If FoundSlicer1Count <> numSlicer1SelectedItems Then

With this change you could also delete all the code related to Slicer2.

 

[Dervos]

Works perfectly!

Thanks again for John.