cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

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.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Filter with "Select All" Off and "Select Single On"- still allows all option

“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.
3.png
“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())
4.png
5.png
Best Regards
Maggie

Re: Filter with "Select All" Off and "Select Single On"- still allows all option

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?

Community Support Team
Community Support Team

Re: Filter with "Select All" Off and "Select Single On"- still allows all option

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