Hi there!
My question is โHow do you intentionally disable the filter in case of a condition is false?โ
Iโm looking forward to seeing the data not filtered if donโt select any value from another table.
I have a data table and a filter table. Whenever I click on a color the filter works beautifully but if I donโt select any color the data is not shown.
IF(ISNOTBLANK([filter_Color]), ANY(Filter[Data_Color]) = [Data_Color], โHereโs where I would like to see all colorsโ)
I have already read a few articles about slices but Iโve not been lucky so farโฆ I have tried words like: False, No, auto. But they donโt seem to work.
Thanks for reading and contribute to this thread.
Solved! Go to Solution.
Either of the following should do what you want:
IF(ISNOTBLANK([filter_Color]), ANY(Filter[Data_Color]) = [Data_Color], TRUE)
or:
OR(ISBLANK([filter_Color]), ANY(Filter[Data_Color]) = [Data_Color])
You FILTER() expression is semantically not correct.
Either of the following should do what you want:
IF(ISNOTBLANK([filter_Color]), ANY(Filter[Data_Color]) = [Data_Color], TRUE)
or:
OR(ISBLANK([filter_Color]), ANY(Filter[Data_Color]) = [Data_Color])
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |