Forum Discussion

gama_thais's avatar
gama_thais
Frequent Visitor
5 years ago

Slicers sync: one way sync and different selection control

Hello community!

 

I wuld have 2 questions about syncing slicers.

 

1. Would it be possible to sync slicers only one way? I.e. I have a slicer for country on page 1 and the same slicer on page 2 (those are synchronized slicers). What I would like to have is that slicer on page 1 will take effect on page 2 but not the other way around. For example, if I select Brazil on page 1, slicer on page 2 should also have Brazil selected. But if I select another country on page 2 this selection should not be taken over to page 1, hence page 1 should maintain Brazil as originally selected.

 

I saw this post: https://community.powerbi.com/t5/Desktop/One-Way-Sync-Slicer/td-p/793475

which asks this same question, but it is not solved yet, as it is from a while ago I thought I could take a shot. Maybe there is currently a solution?

 

2. Is it possible to have slicers that are syncronized to have different selection controls? For example, I wold like the country slicer in page 1 to be single selection, and the syncronized country slicer on page 2 to be multi selection.

 

Thank you in advance for your support!

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    gama_thais , As of now Sync slicer is birdirectional. So both sync.

    Another way is to keep them independent (do not sync) and use drill through from the first page to 2nd page.

     

    The second option I doubt it work on different type, but you can try and check.

    • gama_thais's avatar
      gama_thais
      Frequent Visitor
      5 years ago

      Hi there!

       

      Thanks a lot for your quick reply!

       

      I had seen your suggestion about the drillthrough in the other post, but I made some research and as far as I understood drillthrough must be done with a graph right?! There is no possibility to use drillthrough with a slicer (sorry the ignorance, I have started using power BI recently). If this is the case, it does not apply to me, as my customer wants a slicer.

       

      Also, for the second question, if the synchronized slicers can have different selection controls. Do you have any idea whether that is possible?

       

      FYI.: For those who might be interested and have also no solution, my work around for now was to generate an invalid value to be displayed when there are multiple selections in page 1. I have gauges there, and I used a measure that counts the number of items selected on the slicer, and if it is > 1, I will just return -1.