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.
Select all ignores visual level filtering and user do not see all the values which have been selected.
Same issue reported here https://community.powerbi.com/t5/Desktop/Select-All-doesn-t-work-when-filtering-a-slicer/td-p/721351
Instructions on reproducing the problem:
1. Sample data
Name | Value |
John | 1 |
Mary | 2 |
Emma | 3 |
Luke | 4 |
2. Take name and value into a separate table.
3. Add a new slicer on the page, insert Name into it.
4. Add a visual level filter into the slicer, so that only Luke and Mary are shown in the slicer.
5. Add a Select all option into the slicer.
6. Now, use select all to select all items in the slicer. Then take Mary off from the selected items in the slicer so that select all indicates that multiple selections are made and Luke is the only name selected in the slicer.
7. See the separate table you created. Despite it looks like in the slicer that only Luke is selected, you can see Emma, John and Luke in your table. Now, take name off from this separate table. After this it seems that Luke has value 8, instead of 4 which is the actual truth according to the data.
I hope this demonstrates how dangerous this is for a regular user. Is there already a solution for this? I could not find any.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.