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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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