Forum Discussion
'Select All' doesn't work when filtering a slicer.
A bi-directional relationship doesn't solve the issue, I wouldn't expect it to either. I uploaded the PBIX, Try yourself:
https://drive.google.com/open?id=10QwYrgDYd4pGz8ZIGTUL92KRoh02Tyul
Hi Kashinoda ,
I think you are not trying things the way they work:
1. Visual level filter of EMPLOYEE on your bar chart:
When you select anything on EMPLOYEE, the bar chart will get filtered as it is a visual level filter on your chart. This will not filter the slicer present on the report.
2. Trying to filter the chart using the Slicer present on the report:
This will affect the chart and filters it based on the selection in the slicer.
Now the above screenshots are from the pbix file that you shared.
It looks perfectly fine to me.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
I know how filters work, I've tried to make this example as basic as possible because people are misconstruing the problem. Let me clarify this issue again.
In June 2019 Microsoft added the ability to apply visual-level filters to a slicer, this meant you could restrict the available options within a slicer. This was not possible prior to this date.
In the example I showed, I've limited the slicer to only 'Aaron' and 'Bob. Here it is again for reference.
So here there are only 2 employees available on the slicer, but when I use the 'Select All' button it's selecting all employees - even the ones not included in the visual level filter for the slicer. I would expect to see the SalesAmount for Bob and Aaron only, I don't.
This is probably an oversight on how the slicer handles 'Select All', it's a bug.
Same issue here. I created a new topic about this in the 'Issues' section:
Hi Kashinoda ,
Looks like now I understand the problem. Thanks for detailed explanation 🙂
In order to fulfil your requiremnt, is it right to turn-off "Show Select-All Option" under Selection Controls for your slicer?
Because I think Select-All option still wors on the principal of selecting everything from the column on which slicer is based.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
How do we get confirmation this is a bug or not?
Member123456 - I assume this user is actually a Power BI community admin representative. If so, please can you confirm if what has been described in this thread is a bug or not? If it is a bug, can you raise it as so, or instruct me on how to raise it?
Kashinoda - don't wish to steal your thunder but how you're interpreting the functionality is how, I'd imagine, 99% of users would too.
