Filter Condition at dashboard

[Johny_Freitas]

Hi guys, i have one dashboard with one filter that is working with this filter condition:

AND([problema]=ANY(Filtro[problemas]),
[corredor]=ANY(Filtro[corredor]),
[estacao]=ANY(Filtro[estacao])
)

But if i set only one filter condition, it’s not work.

and i need to work if i set only one too.

Its possible to do it?
i tried to change the condition “AND” to “OR” but doen’t worked.

[Steve · Accepted solution]

Try:

AND(
  OR(
    ISBLANK(ANY(Filtro[problemas])),
    ([problema] = ANY(Filtro[problemas]))
  ),
  OR(
    ISBLANK(ANY(Filtro[corredor])),
    ([corredor] = ANY(Filtro[corredor]))
  ),
  OR(
    ISBLANK(ANY(Filtro[estacao])),
    ([estacao] = ANY(Filtro[estacao]))
  )
)

[Johny_Freitas]

Ty Steve its what i wanted.
But there is one more problem

i need that all column stay in the view.
if one column is blank the next column stay hidding.

if i set one value, the next show up

[Johny_Freitas]

I found the solution, is because the columns are enums with data valid from the left view.