Forum Discussion
Solved
Mysterious page level filter
Hello everyone, I'm new here to post, but long time reader and hope somebody can help me. I have a slicer set up on one several pages of report, which shows just one item in the list - I set it ...
Try two things:
- Select the slicer, then on the Format tab, select Edit Interactions. Select other visuals (most likely slicers) and turn off filtering for the slicer you are having an issue with. Just hit the NONE circle icon.
- On the View tab, check the "Sync Slicers" button. See what slicers on various pages are also filtering other pages.
Somewhere you've got another slicer filtering that slicer, and you just need to work through it to figure out which one it is.
edhans
Community Champion
Community ChampionTry two things:
- Select the slicer, then on the Format tab, select Edit Interactions. Select other visuals (most likely slicers) and turn off filtering for the slicer you are having an issue with. Just hit the NONE circle icon.
- On the View tab, check the "Sync Slicers" button. See what slicers on various pages are also filtering other pages.
Somewhere you've got another slicer filtering that slicer, and you just need to work through it to figure out which one it is.
Hi Edhans and huge thank you,
I found the glitch - not exactly the way you suggested, that this put me in right direction - I just cut all other slisers to new page and started to bring them back one by one to see which is faulty. Found one, (and they are not related in any way and come from different tables), deleted it and created it again - problem solved.
Thank you again....
- edhans
Great. Glad you are back up and running.