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 ...
Need Help
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.