Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Not sure when this started but recently I've noticed that if I had a filter set on a page and I delete it with filters selected it persists on that page. Nothing shows in the filter pane but anything filtered out will not show on that page. If I make a new page and then copy all the visuals they work without filters applied.
Seems to happen when you have synced slicers. Unchecking the box to remove a synced slicer from a page causes the visible on checkbox to show selected, if you then uncheck the visible checkbox (2nd column with eyeball) if you had any filters set they will persist on that page even if you later change or clear the slicer that was orignally synced.
Steps to reproduce the problem
The filter will remain on the page you removed it from with no indication in the filter panel and won't be cleared even if you change the orignal slicer. When removing the slicer it appears to be leaving an orphaned version of the slicer on that page that is hidden. May be working as designed but the fitler should at least show on the page fitlers enabling you to clear it that way.
As a workaround I would suggest either to clear the filter before removing the slicer from one or more of the page, or clear the sync and then go to page(s) you want to remove the synced slicer from and delete the slicer from them by selected and hitting the delete key.
Solved! Go to Solution.
I ran into this problem as well. When I turned on the selection pane, I discovered several hidden slicers. Once I removed those, the page worked perfectly! It seems that when you delete a slicer that has a filter set, you are actually hiding the slicer. The only way to find the hidden slicers is by using the selection pane.
Here's the way I was able to remove "orphaned" slicers.
Hope this helps!!
Similar frustration here, and reported at https://community.powerbi.com/t5/Desktop/Problems-with-Slicers-after-using-option-quot-Sync-Slicers-...
I setup a bug report for it to be fixed - the info here should help them identify. Please vote for it to get rid of this hassle! https://community.powerbi.com/t5/Issues/Sync-Slicers-is-buggy-still-filters-even-after-un-selecting/...
I ran into this problem as well. When I turned on the selection pane, I discovered several hidden slicers. Once I removed those, the page worked perfectly! It seems that when you delete a slicer that has a filter set, you are actually hiding the slicer. The only way to find the hidden slicers is by using the selection pane.
Here's the way I was able to remove "orphaned" slicers.
Hope this helps!!
This is gold. You just saved me
Thank You!!!
It worked great for me! Thanks.
Thank you so much, June of 2021 is still a problem.
This was driving mme crazy, thanks for the solution, it was just what I needed to fix my issue.
Thanks so much!
I faced the same issue. Your solution really healped!
It worked perfectly. Thanks!
I tried giving you two thumbs up!
I'll accept as a soluiton but the intent was to provide feedback to others so they would not fall in to the same frustrating trap I found myself in 🙂
Apparently I have fallen into the same trap. Really frustrating.
Go to the View Tab (next to Home at very top).
Start at the first tab in the file
Select "Selection Pane". That will bring up a panel that shows what is impacting the tab. You will see an eye on the right side. That has an "x" on it if it is not visible.
Select the hidden objects and make sure each one is supposed to be impacting the tab. I recommend doing that with the Synch Slicers tab open also to make sure you are deleting the correct hidden slicers. Also, if the slicer is old and should not be there, if it is synched to other tabs you can unsynch it and the last thing done is delete it.
That should do it.
The amount of time I spent cleaning up slicer is sad. I now use the synch tab always when asigning slicers.
Thanks for accepting as a solution - I agree that this is frustrating and Microsoft needs to look into this further. It's confusing that deleting a slicer only hides it.
Hi @Seward12533,
Thanks for pointing out the problem and sharing the workaround which is very helpfult to others.
Regards,
Yuliana Gu
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
91 | |
84 | |
76 | |
64 |
User | Count |
---|---|
137 | |
113 | |
107 | |
98 | |
92 |