Slicer data hide in second slicer

[Naveennegi119]

Hi All,

I have two same slicer in power bi. if i select data from first slicer, then the second slicer showing same data

but i want to show in second slicer except data of first slicer selected data.

first slicer	Second Slicer
A if A selected	B
B	C
C	D
D	E
E	F
F	G
G	H
H	I
I

Best regards,

NICK

[v-cherch-msft · Accepted solution]

Hi @Naveennegi119

It seems there is no better way to show except data in slicer. But it can be show in table visual. For example: You can make a copy table to get the first slicer value. Then create a measure to get the except data.

Second =
CALCULATE (
    MAX ( 'Table'[first slicer] ),
    FILTER (
        'Table',
        'Table'[first slicer] <> SELECTEDVALUE ( FirstSlicer[first slicer] )
    )
)

Regards,

Cherie

[Naveennegi119]

@v-cherch-msft 

It's working good for me.

Thanks Cherie

Best Regards,

NICK