Forum Discussion

DW868990's avatar
DW868990
Icon for Helper IV rankHelper IV
3 years ago
Solved

Sync multiple slicers across report

Hi,

 

I have a report with 3 slicers, all with the same field from the same table in. Now i am having issue with what I am trying to achieve and not even sure if it is possible, so any advice appreaciated.

I have 3 slicers - Slicer A, Slicer B, Slicer C.

I need Slicer A and C to sync.
I need Slicer B and C to sync.
But, and this is the bit I am struggling with - I need Slicer A and B NOT to sync.

Any advice appreciated.

 

Thanks

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi DW868990 ,

     

    You can use the feature called Edit Interaction. It's under Format in Power BI Desktop.

    For slicer A, cancel the interaction with slicer B and preserve the interaction with slicer C. For slicer B, cancel the interaction with slicer A and retain the interaction with slicer C.

    Below is the result.

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi DW868990 ,

     

    You can use the feature called Edit Interaction. It's under Format in Power BI Desktop.

    For slicer A, cancel the interaction with slicer B and preserve the interaction with slicer C. For slicer B, cancel the interaction with slicer A and retain the interaction with slicer C.

    Below is the result.

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.