I have a data table which has the same column which feeds into 2 slicers (for example same column has Male employee and Female Classification and we may have to compare data among Male vs Female). 2 Slicers are Male data and Female Data. (Male Teens, Male Young Adults, Male Middle Aged, Male Older, Female Teens, Female Young Adults, Female Middle Aged, Female Older)
When we are using Direct query, the moment we select an item in Male slicer, the data will filter only to Male slicer selection. And if we select both Male and Female slicers, no data will show up because both Slicers together will send the data back to data base with “AND”.
If we put the both Male and Female slicer data in one slicer, the data will come perfectly because PBI sends the query to database with “OR” or “IN”. This scenario is not possible because users need separate slicers.
Is there is way we can “OR” the two slicers?