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.
Solved! Go to 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]))
)
)
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]))
)
)
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
I found the solution, is because the columns are enums with data valid from the left view.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |