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

Question

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

cnenfrnl · Answer

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

amitchandak · Answer

324 , you can use single select option in slicer 
&nbsp;
refer if needed
Single Select with Select All : https://youtu.be/plGqCEZRfXU

amitchandak · Answer

324 , you can use single select option in slicer 
&nbsp;
refer if needed
Single Select with Select All : https://youtu.be/plGqCEZRfXU

324 · Answer

Could you ellaborate a bit more on the intrinsic filtering mechanism?&nbsp;CNENFRNL&nbsp;

cnenfrnl · Answer

In brief,

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;
there are handful of filter modifiers (functions) to manipulate the evalution context for desired calculations.

Forum Discussion

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

5 Replies

Related content

Saving filter options

using a slicer to control which attributes a table is filter by

Order attributes

Mass Filter (should not include Exclude option)

Datatable options