Forum Discussion

Naveennegi119's avatar
Naveennegi119
Helper III
7 years ago
Solved

Slicer data hide in second slicer

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 slicerSecond Slicer
A if A selectedB
BC
CD
DE
EF
FG
GH
HI
I 

 

Best regards,

NICK

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

2 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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