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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Offer an Include and Exclude toggle on Slicers

Slicers work great for "inclusion"-type filtering, but not so much for exclusions. It's true, users can select all the items EXCEPT the ones they want excluded, but this is only practical for slicers with a few items. It's not uncommon for applications to have slicers on large tables (thousands of records), so excluding in the same way is not at all practical. Can PBI offer an "Include / Exclude" toggle in its Slicers? When "Include" is ON (the Default setting), the slicer behaves as it does now. When "Exclude" is ON, the slicer excludes the selected item(s). For example, I have a table with thousands of diagnosis codes. I want my report to reflect all patients that DON'T have codes 123.4 or 234.5. Or I want to my report to represent patients NOT in the U.S.
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes