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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      In fairness, I did already mention in the original post that I'd looked at the sync settings but didn't understand how it worked, therefore your suggestion was just asking me to do something I'd already tried at that point. I only got to where I did purely by trial and error with the sync boxes on my own.