Skip to main content

Power BI

Needs Votes

Need slicers group to define AND/OR relatioship betower 2 or more slicers

Vote (14) Share
Eva Zhao's profile image

Eva Zhao on 28 Nov 2017 11:19:23

For example:
I have several flight data, each record have 3 fileds: FROMCITY,TOCITY, FlightDuration.
I use 2 slicers, one is for FROMCITY, and the other is for TOCITY, I need to list all the records that "FROMCITY=Beijing OR TOCITY=Beijing", so I need to set the 2 slicers in an OR relationship....
But now, the default relationship between 2 or more slicers is AND, that means if I set FROMCITY=Beijing ,
TOCITY = Beijing, I can just get the records that "FROMCITY=Beijing AND TOCITY=Beijing".....

Comments (1)
Eva Zhao's profile image Profile Picture

Martin on 05 Jul 2020 23:54:21

RE: Need slicers group to define AND/OR relatioship betower 2 or more slicers

I need this a lot. Workarounds to achieve this are very impractical.
We should be able to choose how the slicers interact with each other (AND/OR)