How to auto change Dashboard filter by yyyymm

as the picture, how to auto set filter by now(yyyymm)?? I must manual control the filter at every month begin.

Hi @Jay
You will need to use Field Filters for that:

But I create all the question by [simple question mode]. Do I need change all the questions to [sql question]??

@Jay Then you will need to convert your data to a date type, so Metabase can understand what it is.
But to answer your question: you'll have to manually update that filter, since your data is created in a way that isn't following any standards, which makes it difficult to work with.
Or you can create a script, which automatically updates the dashboard filter every month via the API: