Hi all, I'm trying to setup a dynamic dashboard with filters following this video from AppSheet training, https://www.youtube.com/watch?v=nK-Aq_ak_T8&t=2830s . I have gotten all filters to work except the filters of YES/NO column. The expression that I'm having trouble with is as follows;
IF(ISBLANK(Dashboard Filter[Carnet Filter]), TRUE, ANY(Dashboard Filter[Carnet Filter])) = [Carnet])
This particular column is YES/NO type. The problem I'm facing is instead of showing all values when the filter is not selected, its shows all values except the item which is in the filter. And when the filter is applied, it shows only the item which is in the filter, which is correct. I need all values to show when the filter is not applied. Anyone can help please?
LinkedIn
Twitter
