Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Disconnect a slicer from a different sheet

Hi - hoping someone can help with a frustrating issue I've come accross. 

 

I have a report built by someone else that is now under my control (and not only am I new to BI but they're not around any more to help). I think when they built it they've duplicated sheets rather than create each one as new, as some of the slicers not only affect the visualisations within the same sheet, but on other sheets as well. When I'm going throough I'm finding which visualisations that are being affected, but I'm not sure which slicer on which sheet is affecting it. I've managed to delete and recreate some of the slicers in the hope it'll fix it but there must be an easier way?

 

I've tried looking at the 'Sync Slicers' option within the 'View' tab, but it really doesn't make any sense to me, and as I've gone through and ticked/unticked the sheet I want to unsync it's made a mess on other sheets... 

 

Hoping someone can kindly point me in the right direction and give me some idiot-proof explanations! 

 

Just to clarify - I want the slicers on each sheet to affect that sheet only and no other sheets, although the same type of slicer will appear on other sheets. So I'll have a slicer for 'year' on sheets 2 and 3 - if I select 2019 for sheet 2, and sheet 3 already has 2017 selected, I don't want sheet 3 to also change to 2019.

 

TIA

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi 

     

    If you are in your report in Desktop, go to View along the top and click Sync slicers. Then a pop up will appear along the right hand side where you can select which tabs that slicer affects. 

     

    Thanks

    Victoria

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    Is there any column in the report page filter? To remove it and edit sync the slicer option to try again.

     

     

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      No, Report Level filters are blank - no filters in this section at all for any sheet. 

       

      I 'think' I've sorted it by using the slicer sync options and unticking any 'sync' boxes (first column) but leaving the second 'visible' boxes (second column) ticked. I am assuming that this means that although a slicer is visible on multiple sheets (as it filters the same category - i.e. 'year'), clicking on a slicer on one sheet won't affect/sync the data across the other sheets it's visible on... Not sure if my understanding is correct though.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yes that is what I had suggested. Would you please mark is as answered if this has worked

         

        Thanks