Slicer clear all not working on single select

[Neutralcats]

Hi, I'm not getting an option to "erase" selections in slicers when single select is toggled on. I DO see it when it's toggled off, and it looks like my slicer header is on. Is Erase all not an option for single select?

[logicscience2]

I have found that you cannot clear a single select slicer, something will always be selected.

However I had a user requirement that a visual must be empty until one and only one selection is chosen from a slicer. This required a workaround.

I used a normal multi-select drop down slicer :

 

With ctrl + click for multi select On, just to make it more difficult to attempt selecting more than one and "Select All" off because that went against the user requirement immediately. Single select off, to allow the filter to be cleared with a "Clear Filters" button.

Then use a measure, applied to the visual as a filter to show information only when a single selection is chosen.

single_ID_selected =
CALCULATE(
    // Check if there is exactly one PersonID selected
    IF(
        // Ensure that the PersonID column is being filtered
        AND(ISFILTERED(all_the_data[PersonID]), 
            // Check if the number of distinct PersonID values is exactly 1
            DISTINCTCOUNT(all_the_data[PersonID]) = 1),
        1, // Return 1 if both conditions are true
        0  // Return 0 if either condition is false
    ),
    // Apply all existing filters in the current context
    ALLSELECTED(all_the_data)
)

In addition to that when the visual was blank there was a user instruction text box which said "Select a single person ID from the filter" If the user pressed CTRL + click on a second person ID the visual would go blank and the user instruction reappears as a reminder of the functionality.

[v-henryk-mstf · Accepted solution]

Hi @Neutralcats ,

After testing, the clear icon is not displayed when the slicer is unchecked.

If you want to achieve the same effect on a single filter, you can try to create a button, set to clear all filters when clicked, refer to the following blog:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MahyarTF]

Hi,

In Slicer, if you disable the Slicer Header format, the eraser selection is disappeared 

[ronaldbalza2023]

I think the erase all is not an option for a single select. Have a read on this 😉
Solved: Re: Clear all slicer selection when single select ... - Microsoft Power BI Community