Forum Discussion
Slicer Weirdness.
When all Years are selected in my Year slicer - The select all tickbox is not selected.
When nothing is selected, still data is being displayed.
Please help. New to BI.
Hi HHBaraskar
This is the natural behavior of slicers.
"Select All" is only activated when the "Select All" is clicked.
If you select all the values one by one, functionally it will work like "Select All" and the visualizations will be filtered accordingly.
However, the option will not be marked as "selected".
When a user does not select anything in the slicer, it is treated by the engine as if they have selected everything.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
3 Replies
Hi HHBaraskar
This is the natural behavior of slicers.
"Select All" is only activated when the "Select All" is clicked.
If you select all the values one by one, functionally it will work like "Select All" and the visualizations will be filtered accordingly.
However, the option will not be marked as "selected".
When a user does not select anything in the slicer, it is treated by the engine as if they have selected everything.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
But, until I made a few changes by modifying filers to show 2019, 2020 & 2021, it was selecting "Select All" option automatically when I had only 2023 & 2024 and I selected both of them in slicer.
Hi HHBaraskar
if you'll share the link for the pbix i will be happy to check it.
