Dashboard filter by Year

For time filters, there is not an option to filter by Year only. I have a report that shows values year over year, and would like to create a filter so that the consumer of the report can filter down to particular year/years. Is this possible?

Hi @b.penn
There's currently no year filter, the closest is Number filter:
https://github.com/metabase/metabase/issues/10477 - upvote by clicking :+1: on the first post

Hi @b.penn,
You can duplicate the date column and use SQL function to show only the year from the date. For example, in PGsql is SELECT EXTRACT(YEAR FROM TIMESTAMP '2016-12-31 13:30:15');


Then you can filter by year