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]))
)
This makes me think it is something weird with the ISNOTBLANK() portions of your expression.
Maybe try to change them to:
ISNOTBLANK( ANY( Filter Table[column] ) )
Notice the addition of ANY().
Nope no effect either
Hmm, ok. Maybe try to convert your
IN( [x] , Table[col] )
โฆportions to:
[x] = ANY( table[col] )
??
Iโve built this same feature in many apps, and just checked two of them and they still work fine. I always write the expressions as Iโve just asked you to try, though yours shouldnโt definitely work as well.
Nope. Not working either. Whatโs weird is that it works when you use the test feature, but it doesnโt when you โView Dataโ on the filtered slice.
Please provide screenshots of this.
Possible that the Filter Table has more than one row? isblank(Filter Table[...])
only works for your purpose if the table has only one or no rows.
The table in โView Dataโ is no longer blank but the dashboard remains as such. Does the problem lie closer in the structure of the Filter Table?
Canโt say yet.
The views included in the dashboard actually use slices that use the filter table? Youโve confirmed?
Yep. The dashboard has the slice versions of the filter table and the filtered main
Please post the configuration for this table:
Are these what you mean?
What did you do to get the screenshot I used above, that shows no rows? If View Data from a slice, please post a screenshot of the configuration of the slice.
Yep. View Data from the slice and that was before you suggested to eliminate the empty rows.
Now Iโm confused. You did delete some blank rows from Filter Table? And after doing so, View Data on the slice now shows the correctly filtered rows? But the dashboard does not show the correctly-filtered rows?
Yes
Please post a screenshot demonstrating an affected dashboard view is correctly configured to use the now-working slice.
Itโs just empty while the filters are blank
I need to see the configurations.
No.
Yes, thank you!
The configuration does in fact appear correct, so again Iโm think the problem is with the slice. Try using the following as your slice row filter expression instead of what you have currently:
[_ThisRow] = minrow("Filter Table", "_RowNumber", (useremail() = [Email]))
Still nothing
Iโm afraid Iโm at a loss, then. Iโm going to have to recommend you engage Support so that someone there can look at your app configuration.
Maybe the filter is interpreting it as looking for blank columns? Caregiver/Installer is a ref type column that bases its info on the Id of field employees and some rows in estimate have a blank caregiver/installer column. I got the notion when I isolated the filter formula down to a single criterion:
or(isblank(Filter Table[Installer]),in([Caregiver/Installer],Filter Table[Installer]))
and this is what happens:
and this is what the result are when someone is selected
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |