Forum Discussion

UBComma's avatar
UBComma
Icon for Helper III rankHelper III
3 years ago
Solved

Display items not selected in a slicer

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?

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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
)

     

     

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      UBComma
      Icon for Helper III rankHelper III
      3 years ago

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