OR Selection with Multiple Slicers

[sheap069]

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

[CNENFRNL]

For fun and to show off the power of Excel,

[dhruvinushah]

@sheap069 Hi, 
you can split the fields in your table to seperate 'dimensions' as @CNENFRNL  has done in the Power BI file shared in their reply. 

[dhruvinushah]

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 Community

Hope 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!