Forum Discussion

mayurwadhwani's avatar
mayurwadhwani
Icon for Helper I rankHelper I
5 years ago

Sync Slicer On Same Page Query

Hello Experts,

 

I have two slicers say S1 (Column Name: Region) and slicer S2 (Column Name: Region). Both slicers are created on same column and on same page of power bi report.

Values in column Region are: R1,R2,R3,R4,R5.....Rn

 

My requirement is when I select R1 and R2 in slicer S1, same value should get selected in in slicer S2. This I have achieved using sync slicer. But I dont want to sync slicer S2 to S1. Means when I select R4 in slicer S2 it should not get reflected in Slicer S1. But whatever selected in slicer S1 should reflect in slicer S2.

 

Any help or suggestion would be highly appreciated!!

 

Thanks,

Mayur

Need Help

7 Replies

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

    mayurwadhwani , I doubt you can do that. If S1 and S2 are from same column, Then even if they are not sync in display. the values are sync in backend .

     

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

        mayurwadhwani , One independent table and one joined table can do. No how will pass the values selected on slicer1( Joined) to Slicer 2, and that only select . I doubt any such function as of now

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, mayurwadhwani 

     

    A slicer can decide which items are selectable in another slicer instead of which items are selected in another slicer. You may try 'Edit interaction' to see if it meet your requirement. I created data to reproduce your sceanrio. The pbix file is attached in the end.

    Table:

     

    You may go to 'Format'=>'Edit interaction'.

    1. Make 'Slicer1' selected, turn on the filter from 'Slicer1' to 'Slicer2'.

     

    2. Make 'Slicer2' selected, turn off the filter from 'Slicer2' to 'Slicer1'.

     

    Result:

     

    Best Regards

    Allan

     

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

    • mayurwadhwani's avatar
      mayurwadhwani
      Icon for Helper I rankHelper I
      5 years ago

      Thanks v-alq-msft  for the response. 

      I do not want other values from Slicer S2 to be disabled once I select any value from Slicer S1. For Ex: If I select R1 value from Slicer S1 then in Slicer S2 value R1 should get selected and in dropdown it should show all the other values as well.

       

      Thanks

      • v-alq-msft's avatar
        v-alq-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, mayurwadhwani 

         

        Unfortunately, It is unavailable to make items selected in a slicer affected by another slicer. Slicers can decide which items are selectable rather than selected in other slicers. It is designed like this.

         

        Best Regards

        Allan

         

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