Filter with "Select All" Off and "Select Single On"- still allows all options to be selected

[OneWithQuestion]

I have a filter control, it lists values as would be expected.

It has Show "Select All" option = Off

Single Select option = On

The issue is that if someone clicks on the filter and clears the selection it selects all the values (or removes the filter).

Is there anyway to REQUIRE a selection on the filter?

If nothing is selected then I don't want any data to be returned.

Basically, without a selection I want it to select "none" as opposed to "all".

If you clear the selection the drop down even says "All" even though Select All is off.

[v-juanli-msft]

Hi @OneWithQuestion

“if someone clicks on the filter and clears the selection it selects all the values (or removes the filter)”

I can reproduce the situation as follows.

“If nothing is selected then I don't want any data to be returned”

This requirement can be achieved by creating a measure based on the column you want to view.

Measure = IF(HASONEVALUE(Sheet1[if]),MAX([col]),BLANK())

Best Regards

Maggie

[OneWithQuestion]

Thank you, and yes that would be the desired behavior.

However, to make that work I would have to make new measures for every single column of data I want to display.

I already have data models with hundreds of measures (or just columns used as attributes).

Is there no way to set a filter to behave like a prompt where nothing happens until you provide a selection?

[v-juanli-msft]

Hi @OneWithQuestion

Your requirement seems to be something like "the slicer should not return results when nothing is selected".

Currently, it doesn't support in Power BI desktop.

you can vote a similar thread here.

Best Regards

Maggie