Date filter works but week filter not working in Metabase

Get Help
1

Hi,

I am working on a Metabase dashboard and the week filter is not working correctly.

Day and month filters work fine, but when I select week, the dashboard is returning an error saying “There was a problem displaying this chart” .

The filter is applied on a date column in the dashboard.

Is there any special configuration needed for week filters in Metabase?

Thanks in advance.

2

What was the error? There should be some explanatory text or exception there. That or check the log for it.

Also, what Metabase version and what database?

3

Hi,

Thanks for the response.

The error shown on the dashboard when selecting the week filter is:
"There was a problem displaying this chart."
No additional message is shown in the UI.

Metabase version: version v0.56.2.4
Database: PostgreSQL

The filter is applied on a column that stores date/time values, and day/month filters work correctly.
The issue happens only when selecting the week option in the dashboard filter.

Please let me know if week filters require any specific configuration for this database type.

4

Try to open the dashboard, then go to Admin → Tools → Logs. The exception should be there.

5

Week filter issues with PostgreSQL often come down to timezone mismatch. Check Admin > Settings > Localization to make sure Report Timezone is explicitly set. Also check Admin > Tools > Logs when the week filter fires to see the actual SQL being generated.