Dashboard Filter appears wrong in Report - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Udo KerwathUdo Kerwath 

Dashboard Filter appears wrong in Report

Hi! In a dashboard, the results are displayed properly in a stacked bar chart using a dashboard filter on "Schedule Date".

User-added image
Clicking on one of items (here one product for April 2019), I get an empty report. Looking at the Linked Filters, it is clear why: a third Filter is added on top of the two for April 2019, "lesser or equal 1970". Where does this come from? Is it a bug? Can I avoid it?

User-added image
Thanks,
Udo
Udo KerwathUdo Kerwath
Additional Info: It looks like ***any*** date I put in the Dashboard filter, be it with lesser or greater than, is translated into "1970-01-01". 
Udo KerwathUdo Kerwath
Just to let you know what the cause and work-around are.

Cause: Using the Locale "German(...)" caused the wrong date to be used in the report filter.

Workaround #1: use the locale "English (USA)"
Workaround #2: use relative dates instead of absolute

Happy dashboarding,
Udo