Dear Community,

Lets say i have a list of projects that have a column with 'Main responsible' and a column 'Second responsible'. I cannot change this.

There are about 100 people involved in 20k projects. They can be main responsible, or second. Every project has at least one main responsible person.

Now, they want to use a slicer so people can immediately see all there projects. This is a problem, as a slicer snaps only to one of the two responsible columns. Selecting your name in both the slicers will lead to zero rows : it will instead search for projects where you are both first and second responsible, which is not possible.

Is there a way to put these two slicers in OR functionality? I realize this also gives a new problem: selecting a name in only one slicer has no effect: all other names are active in the other slicer so therefore all rows would still be valid.

I have thought of one 2-step solution (which sucks imho):
- have a sub table created only containing a list of all unique names of both columns.
- create a pivot of it
- attach a slicer to it.


- when pivot updates (macro) mark with 1/0's all relevant rows in the original dataset, and filter out all '0' values.

Better solution anyone? sigh