Forum Discussion
Helper IIIOR Selection with Multiple Slicers
Hi,
I have data as follows, and it can be downloaded here:
| application id | province | employer | citizenship | company | institution |
| 1 | Ontario | B | canada | A | B |
| 2 | Yukon | C | France | B | D |
| 3 | Alberta | A | Australia | C | E |
| 4 | Manitoba | C | US | D | F |
| 5 | British Columbia | A | US | A | F |
| 6 | Ontario | B | canada | B | A |
| 7 | Ontario | C | canada | C | A |
| 8 | Quebec | C | Australia | C | B |
| 9 | Quebec | D | Australia | D | C |
| 10 | PEI | A | France | B | D |
| 11 | Alberta | A | Australia | B | E |
| 12 | Alberta | D | India | A | F |
| 13 | British Columbia | D | India | D | F |
| 14 | Alberta | C | canada | C | C |
| 15 | Saskatchewan | D | India | B | A |
| 16 | Yukon | B | India | A | B |
| 17 | Ontario | B | Australia | B | B |
| 18 | Quebec | B | France | C | D |
| 19 | Quebec | C | US | D | C |
| 20 | Ontario | A | US | D | C |
I have slicers for all of these columns and I have charts with application volumes. How can I get the tables to represent the number of applications with the following criteria:
Province: Ontario
OR
Employer: C
OR
Country: US
OR
Company: B
OR
Institution: F
where those are slicer selections.
Thank you
3 Replies
- dhruvinushah
Responsive Resident
Hi sheap069 ,
Be default and by definition, slicers are used to slice the data and work with the 'AND' logic in Power BI. You can change the interaction in the slicers to show all the values but in the table if they are coming from the same table, the slicers will 'filter' the data in the 'AND' condition.
Refer: Solved: Power BI slicer OR condition - Microsoft Power BI CommunityHope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks! 
CNENFRNLCommunity Champion
For fun and to show off the power of Excel,
- dhruvinushah
