Forum Discussion
'Select All' doesn't work when filtering a slicer.
The new slicer filtering is great but it appears to be broken when using the 'select all' functionality. Is this just me?
24 Replies
This issue still seems to be present in the June 2023 version. Has anyone come up with a solution yet? It's creating an awful lot of extra effort to produce a workaround.
I read it works as expected form product team but from the user perspective this is definetly not what we expect to happen! Still unsolved even if a lot of people want that feature. thanks microsoft
Hi Kashinoda
Based on my test.the option works well.I would suggest you update to latest version of Power BI Desktop then try again.Below is the article about the new filter pane.
https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview
Regards,
I'm already on the latest version, I updated again anyway to be sure and the error is still there.
Visually it looks to work on the slicer, but the data does not filter. Try adding a visual to your demo and see if that works.
Hi Kashinoda
Visual level Filters- These filters work only on visualizations.
Page level Filters- These filters work at the page of a report.
Report level Filters- These filters work on entire report including all pages and visualizations.
If you want the filter work for the two visuals,i would suggest you use page level filter.
Regards,
Pragati11- I'm not the person you're addressing but I have the same issue.
I can confirm that the field used in the Filter visual and Table visual is the same field. I have just removed that same field from both visuals and then put it back in those visuals to see if removing it/adding it will trigger/refresh it to work. I'm afraid it still doesn't work.Kashinodahas provided a very good demonstration of this issue faced.
Back in 2020 I got the response to this that it works as designed:
https://community.powerbi.com/t5/Issues/quot-Select-all-quot-behavior-on-a-slicer-while-visual-level/idi-p/1138925#M57578
Not very user friendly
All,
I have cobbled something together that addresses this issue for me.
It makes use of HierarchySlicer from DataScenarios which can be downloaded from the Power BI store.
I don't make use of the hierarchy part, but that looks nice too.
There is a Select All, which doesn't actually select all as we know, just like the standard slicer.
But what it does do is let me ctrl click the first selection to unselect it then ctrl click again to reselect it.
When I do that suddenly ALL of the items are ACTUALLY selected and filter my table.
This is different behavior from the standard slicer as I have tried the same thing with it and it doesn't work.
No more individually ctrl clicking dozens of items to select them.
No more hoping MS enables shift clicking to select a range of items.
What would be perfect if clicking Select All did SELECT ALL and not make me do the ctrl click - click step.
Give it a try!
jim
