cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Mystery filter in Desktop and Service

Hi everyone,

 

I am having a tough time finding the source of a filter that appears on a specific page of my report. This is in Power BI Desktop but the same thing can be seen in the Service. In the first screenshot below, you can see the filter summary of one of my visuals. The first date filter is a valid filter that I have set on the visual itself. This can be seen when looking at visual level filters in the filter pane. It comes from my Date_Dimension[DateKey] field, but I have changed the name of the fitler to "Date".

 

The second date filter is where the problem is. I do not have a date filter on the page level at all. At least not that I can see. I can confirm this in the filter pane. Even though the data is coming out correct (only for the month of January 2020), I want to be able to tell users that they can use this view to verify their filters. Obviously as it stands this would cause a lot of confusion. 

 
 

Mystery Filter 1.PNG

 

Things I have tried which did not help:

1. Updated Power BI to Feb 2020 release.

2. Closed and reopened the .pbix in Power BI Desktop.

3. Added a page level filter to the page using the same column as the mystery filter, then deleted it.

4. Created a duplicate page

 

The only thing that seems to get rid of that filter is if I copy just one of the affected visuals and then paste it onto a new page. Like magic, the mystery filter is gone.

 

Myster Filter Gone.PNG

 

So my question is, how else can a page level filter be applied like this? I do have drillthroughs but this specific filter is not applied on other pages. I also have "Keep all filters" turned off.

 

Thank you!

1 ACCEPTED SOLUTION

@Anonymous 

 

I agree with you wholeheartedly on your last statement. It can be very disconcerting.

I don't actually think the issue is synched slicers (since the field from the slicer does not appear/isn't actually filtered on the filter pane)

But just to make sure...

If you do happen to have a hidden slicer on your page, you won't actually see it listed in the Synch Slicer pane (believe it or not..!)

Here is an example.

The first page has a year slicer, and I have made it synch with another page ("Duplicate of Actuals"). I have also made it hidden in the "Duplicate of Actuals" page (see the details in the synch pane)

Synch Slicers 1.JPG

 The "Duplicate of Actuals" page is as follows (table and card visuals; no slicers):

Synch Slicers 2.JPG

Since they are Synched, the table and card visual are filtered accordingly (but no clues in the filter pane - the visuals are not selected but I've checked-, which is why I believe it is not your issue). Since there are no slicers on the page (the only one is actaully hidden), you cannot actually check for any hidden slicers (the Synch Slicer pane is empty); to check if there are any hidden you need to go to a page with a "suspicious" slicer for a field and see with which pages it is synched etc. If you try adding a "suspicious" slicer to the page to check if it is in sync you won't see slicers from other pages)

 

Anyway, just thought it might be worth illustrating just in case...

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

6 REPLIES 6
PaulDBrown
Super User
Super User

@Anonymous 

 

Check under view/sync slicers if you have inadvertedly included a "hidden" slicer on the page synched to another table. If not, it is most probably the drillthrough slicer as @amitchandak points out...

rogue slicer.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Thank you for the responses everyone.

 

First I double checked my drill-through filters:

Mystery Filter 2.PNG

 

Then I double checked that there were no synced slicers:

Mystery Filter 3.PNG

 

I also checked to make sure that "Data" has been unchecked on my bookmarks:

Mystery Filter 4.PNG

 

Unfortunately it is still there. I hope that in the future Microsoft will consider adding details about the origin of each filter in the visual filter summary. Any other ideas?

@Anonymous 

 

I agree with you wholeheartedly on your last statement. It can be very disconcerting.

I don't actually think the issue is synched slicers (since the field from the slicer does not appear/isn't actually filtered on the filter pane)

But just to make sure...

If you do happen to have a hidden slicer on your page, you won't actually see it listed in the Synch Slicer pane (believe it or not..!)

Here is an example.

The first page has a year slicer, and I have made it synch with another page ("Duplicate of Actuals"). I have also made it hidden in the "Duplicate of Actuals" page (see the details in the synch pane)

Synch Slicers 1.JPG

 The "Duplicate of Actuals" page is as follows (table and card visuals; no slicers):

Synch Slicers 2.JPG

Since they are Synched, the table and card visual are filtered accordingly (but no clues in the filter pane - the visuals are not selected but I've checked-, which is why I believe it is not your issue). Since there are no slicers on the page (the only one is actaully hidden), you cannot actually check for any hidden slicers (the Synch Slicer pane is empty); to check if there are any hidden you need to go to a page with a "suspicious" slicer for a field and see with which pages it is synched etc. If you try adding a "suspicious" slicer to the page to check if it is in sync you won't see slicers from other pages)

 

Anyway, just thought it might be worth illustrating just in case...

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Anonymous
Not applicable

@PaulDBrown 

 

Thank you!!!! Your post made me take a closer look at my Selection Pane list and sure enough, down at the very bottom was a slicer I had created and then hidden during the very early stages of development. This was causing the mystery filter. I can't believe I didn't check this before but out of sight out of mind I suppose. 

 

Thanks again to everyone who helped me work through this!

DS12345
Frequent Visitor

Hi @Anonymous,

 

Are you using bookmarks by any chance? It could be that you have a filter set in your bookmark, which keeps returning to your visual whenever you go the bookmark.

 

Hope this helps.

amitchandak
Super User
Super User

When you drill through, The filter remains there you have to clean up. Both desktop and Webapp have a difference in how you remove it.  Also, report level filter can impact, but as on new page, you are not getting. Seem like that is not an issue.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!