Forum Discussion
April fools?
Thanks for the response Yuliana.
Yes - there is plenty of data in there for that date. A simple SQL count by date against the source table (and it's a single table driving the dashboard, so no complexities around table joins to consider) shows tens of thousands of records.
As you'll be aware, when you include a filter in the filter panel, using "basic filtering", the number of records shows up next to each available selection. Curiously, the correct number of records is displayed in this list, but selecting the April quarter blanks out every visualization! But, if I very simply replace the filter with my new text-based version of the date, it works beautifully.
It's inexplicable, and I have absolutely no clue if anyone is able to reproduce it. Unfortunately, it's not easy for me to share the dash to demonstrate, as it contains sensitive data.
I can confirm that we are also experiencing this issue.
I have noted that the issue seems to affect Slicers that are set to April 1st.
Not all kinds of date slicers seem to suffer the issue, however. I have noted that Dropdown and List do have the issue. Other types do not.
Notably, I do not experience the problem with setting the date by the Advanced Filter, but the Basic Filter displays nothing.