Monthly date parameter

How can I reflect a monthly date as a filter to my dashboard, I want is like a kind of control or sort, e.g. a dropdown list or a click tab that my users can use to filter the dashboard by month or even via quarter or year.

Hi @sharmagneo, you can try to define a new calculated field extract(MM, date) and manually type in 12 months as a parameter list to filter on the calculated field.

1 Like

Ok will try this thank you!

@sharmagneo We hope Emily’s solution works. If it does, please let us know by marking her answer as “Solution.” Of course, let us know if the problem persists / if you need additional help. Thanks!

Hi @sharmagneo , Did @emilyzhu solution work for you? I am marking the reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!