No filter of blank data

[NoamShnarch]

Hello everyone, 

So i made a filtering screen with 2 dropdown lists. I want that I will have the option to not fill the 2 of them so I could filter by only 1 dropdown if I will want. 

The problem is that when the dropdown is blank it searches for blank content and its giving me nothing.

How can I make blank dropdown to just not filter?

This is an example of my function:

Filter(Data,column1=dropdown1.selected.qqq,column2=dropdown2.selected.www)

Thank you in advance. 

[RandyHayes]

@NoamShnarch 

Please consider changing your Formula to the following:

Filter(Data,
    (IsBlank(dropdown1.Sselected.qqq) || column1=dropdown1.Selected.qqq) &&
    (IsBlank(dropdown2.Sselected.www) || column2=dropdown2.Selected.www)
)

I hope this is helpful for you.

[Drrickryp]

@NoamShnarch 

Filter(
    Data,
   IsBlank(Dropdown1.Selected.Value) ||qqq = Dropdown1.Selected.Value, 
   IsBlank(Dropdown2.Selected.Value) ||www = Dropdown2.Selected.Value
)

[NoamShnarch]

Im getting this error, do you know what should I do? 

 

[Ricardo_Costa]

You can just use "In" instead "="

Filter(Data,dropdown1.selected.qqq In column1, dropdown2.selected.www In column2)

blank is in every content that is how I usually filter

[RandyHayes]

@NoamShnarch 

Are those Choice columns in your datasource?  If so, then append a .Value at the end of your column name in the formula.