Implement Dynamic date filters(YTD, Last 12 Months, Custom)

[Brett]

Hi @Madhura28 and welcome to the QuickSight community!
I would take a look at the following articles that cover similar principles:

Dynamic date hierarchy selection

Use Case for Dynamic Date Hierarchies In QuickSight, analysts (authors) can create dashboards with multiple visuals, which are consumed by QuickSight end users (readers). Readers can interact with dashboards by applying filters, drill-down/roll-up data or invoke custom actions. But unlike authors, readers have limited ability to customize attributes within visuals. Authors have the ability to provide readers with further controls to change visualizations beyond simple filtering and drill-down/…

Dynamic Date Formatting

Hello! I have a daily_date in my dataset and a reporting_period control that has Week, Month, Quarter and Year as grain selection options. This is how the formula looks (below) [image] My question is - when a user selects Year, I want to display 2023 instead of Jan 31, 2023. Is there a way to achieve that? I saw Dynamic date hierarchy selection to do this but I don’t want to change my date datatype to string by doing this because I need to use this date for more calculations that need a dat…

Let me know if you have any additional questions