cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sheap069
Helper III
Helper III

OR Selection with Multiple Slicers

Hi,

I have data as follows, and it can be downloaded here:

application idprovinceemployercitizenshipcompanyinstitution
1OntarioBcanadaAB
2YukonCFranceBD
3AlbertaAAustraliaCE
4ManitobaCUSDF
5British ColumbiaAUSAF
6OntarioBcanadaBA
7OntarioCcanadaCA
8QuebecCAustraliaCB
9QuebecDAustraliaDC
10PEIAFranceBD
11AlbertaAAustraliaBE
12AlbertaDIndiaAF
13British ColumbiaDIndiaDF
14AlbertaCcanadaCC
15SaskatchewanDIndiaBA
16YukonBIndiaAB
17OntarioBAustraliaBB
18QuebecBFranceCD
19QuebecCUSDC
20OntarioAUSDC

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 3
CNENFRNL
Super User
Super User

CNENFRNL_0-1654028371823.png

 

For fun and to show off the power of Excel,

CNENFRNL_1-1654028804560.gif


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is beyond their comprehension!

DAX is simple, but NOT EASY!

@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
Super User
Super User

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!









Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors