Display items not selected in a slicer

[UBComma]

Does anyone have a clever suggestion on how to show a dynamically rendered list of items showing what has been filtered out by a slicer? For example:

I have a list of items where the full list is this

ITEMS

Item 1

Item 2

Item 3

Item 4

Now apply a slicer to the ITEMS table and select Item 2 and Item 4

From this action I want to display two tables, one with the selection, and one with the items not selected, like this:

SELECTED ITEMS

Item 2

Item 4

UNSELECTED ITEMS

Item 1

Item 3

Any thoughts on how to do this?

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I suggest having a disconnected slicer like the sample pbix file, and add a condition measure into Visual Level filter pane.

items selected: = 
SWITCH (
    TRUE (),
    NOT ISFILTERED ( Slicer[Item] ), 0,
    COUNTROWS ( FILTER ( Data, Data[Item] IN DISTINCT ( Slicer[Item] ) ) ) >= 1, 1,
    0
)

items not selected: = 
SWITCH (
    TRUE (),
    NOT ISFILTERED ( Slicer[Item] ), 0,
    COUNTROWS ( FILTER ( Data, Data[Item] IN DISTINCT ( Slicer[Item] ) ) ) = 0, 1,
    0
)

[UBComma]

Very good! I think that's going to work. Thanks so much for your help!