Andreas Balzer on 09 Sep 2015 23:42:00
Slicer should allow allow exclusion of items.
Administrator on 01 Dec 2016 00:56:03
In the formatting pane, you'll see an option to turn on Select All. This lets you toggle everything selected, and then just deselect the items you want to exclude. Thanks!
- Comments (2)
RE: Slicer should allow excluding
That was not the ask. That solution is poor UX as soon as you have more than a handful of values in your slicer.
RE: Slicer should allow excluding
Hi @Will Thompson,
Yes, that's true - you can simply select all the times except for the ones you want to exclude and you get the desired results. However, this is only practical for slicers with a small number of 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 it's Slicers? When "Include" is ON (the Default), the slicer behaves as it does now. When "Exclude" is on ON, the slicer in effect does a SQL-ish NOT IN ("the","selected","values") so that whatever item(s) were picked are excluded.