Forum Discussion
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 filtered up somehow at the beginning working on report and don't remember how i did it. Now I need to remove this filter, but can't figure how - there is no any visual, page or report level filters!....
Filtered page
The funny thing is that if I copy and paste this exactly slicer into new page, It shows all the options, and this drives me crazy.
I suggest this might have simplest solution ever, but I cant figure this out for two days already and really hope somebody can help me....
Thank you upfront, Natalia
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.
3 Replies
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.
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....
Great. Glad you are back up and running.
