User Profile
pbi_developer
Advocate I
Joined 6 years ago
User Widgets
Contributions
Re: "Select all" behavior on a slicer while visual level filter is applied
Ok, thank you. From user's point of view this is quite bad design, because you cannot see what you have selected from the slicer if the visual level filtering is applied. This makes the combination unusable.3.6KViews0likes0CommentsRe: "Select all" behavior on a slicer while visual level filter is applied
Thank you for your effort, it seems you do have the same issue. 1 + 3 + 4 = 8, when you set automatic summarization for Value. So 1 and 3 are values for John and Emma, not for Luke. The slicer has the two other names secretly selected, though user thinks he/she has only selected Luke.3.7KViews0likes0Comments"Select all" behavior on a slicer while visual level filter is applied
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.3.8KViews8likes7Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.