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...
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
)

     

     

     

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!