Table Visualization for Selected Slicer Subgrouping

HI Anonymous,

For original slicer, it is impossible to achieve your requirement.

You need to create new table as source of slicer and coding measure to filter records.

Steps:

1. Create table with 'item number' and 'groups' from original table as select table.(these tables not have relationship)

Selector =
SELECTCOLUMNS ( Table, "Item Number", [Item Number], "Groups", [Groups] )

2. Use Item Number(from selector table) as source column of slicer.

3. Write measure to get selected group list and check original table row content to return tag.

Tag =
VAR selectList =
    CALCULATETABLE ( VALUE ( Selector[Groups] ), ALLSELECTED ( Selector ) )
RETURN
    IF ( SELECTEDVALUE ( Table[Groups] ) IN selectList, "Y", "N" )

4. Drag above measure to visual level filter with advanced filter mode to filter records who not equal to "Y" tag.

Regards,

Xiaoxin Sheng