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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
324
Helper I
Helper I

Filtering Options: Filter Either One Attribute OR Another One (But NOT Both)

Is it possible to allow the user to filter by either Attribute A or Attribute B but NOT both? I don't want the user to be able to filter on both Attribute A and Attribute B at the same time, but rather, I want them to pick one or the other. Is this functionality possible in Tableau? 

 

For further clarity, this is what I'm trying to do (but this is for Tableau). Is it possible to perform a similar operation in Power BI?

 

Thanks in advance!!!

5 REPLIES 5
CNENFRNL
Community Champion
Community Champion

Due to intrinsic filter mechanism, it's way much easier in PBI,

CNENFRNL_0-1655994315433.png


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!

Could you ellaborate a bit more on the intrinsic filtering mechanism? @CNENFRNL 

CNENFRNL
Community Champion
Community Champion

In brief,

  1. All elements, such as columns/rows of viz, slicers, crossfilters, page-level filters, etc, produce filtering effects; along with some row context, they constitute the evaluation context for DAX expression calculations;
  2. there are handful of filter modifiers (functions) to manipulate the evalution context for desired calculations.

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!

amitchandak
Super User
Super User

@324 , you can use single select option in slicer

 

refer if needed

Single Select with Select All : https://youtu.be/plGqCEZRfXU

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
amitchandak
Super User
Super User

@324 , you can use single select option in slicer

 

refer if needed

Single Select with Select All : https://youtu.be/plGqCEZRfXU

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.