Forum Discussion
Slicer "AND' Operator
Lets say I have 2 tables A UNIT table and an OPTION table and the two tables are related by UnitID.
In my report I have an Option slicer and a visual displaying UnitId and Option. Lets say in my slicer i have selected OPTION 35B. In my visual I will see UnitID's, 123,456 and 987. But lets say I select in my slicer both 35B and 12A. I only want to see 123 and 456. I DO NOT want to see 987 because it does not have Option 12A. Is this possible? If so how?
| UnitTable | OptionTable | ||
| UnitID | OptUnitID | Option | |
| 123 | 123 | 35B | |
| 456 | 123 | 12A | |
| 987 | 123 | 66F | |
| 456 | 77X | ||
| 456 | 35B | ||
| 987 | 35B | ||
| 456 | 12A | ||
| 987 | 899K | ||
| 987 | 77X |
