Last month, my dynamic dashboard filter stopped working. The filtered table showed no results when the filter itself is blank. It’s only when you have filled all criteria that a result would show up, but that has not been the effect of the formula until now. I also tried variations of the formula but they did not work either. Was there an update that affected this? Below are some of the resources I used to create the formula and the formula itself.
And(
or(isblank(Filter Table[Insurance Filter]),in([Insurance],Filter Table[Insurance Filter])),
or(isblank(Filter Table[Line Item Filter]),in([Line Item],Filter Table[Line Item Filter])),
or(isblank(Filter Table[Project Type]),in([Project Type],Filter Table[Project Type])),
or(isblank(Filter Table[Installer]),in([Caregiver/Installer],Filter Table[Installer])),
or(isblank(Filter Table[Status]),in([Status],Filter Table[Status])),
or(isblank(Filter Table[Region]),in([Region], Filter Table[Region])),
or(isblank(Filter Table[City]),in([City],Filter Table[City]))
)
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |