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.
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.
Is there any column in the report page filter? To remove it and edit sync the slicer option to try again.
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.
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.