Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Working with slicers one needs to pay attention to the fact that Slicer means Filter in Power BI.
If nothing is selected, it means that nothing is filtered out, report shows all data as is.
Let us have a look at some use cases.
Case 1 All selected
Case 2 Nothing selected
This behavior follows the logic 'All selected' = equals to 'Nothing selected'.
There is actually no way to filter out all data at all. It is really very disappointing.
But the stange thing happens when you unselect all items from drop down one by one.
If you unselect one item all is perfect.
But when you unselect all items you see the following
Case 3 Unselected one by one
In this case the slicer still shows 'Multiple selection' and report shows no data at all.
That is really confusing.
And actually that is what I expect to see in Case 2 Nothing selected
Can you explain me if this is a bug?
I need to expain this behavior to the users of my report.
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.