Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Community Champion
Community Champion

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 still way 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
Responsive Resident
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 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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.