Default Date Parameter Not Picking Dynamic Default on 1st of Month

Q&A
,
1

I’m facing an issue where my Quick Sight dashboard resets the parameter value to the 1st of the current month on July 1st and does not include data for June 30, even though I’ve configured a dynamic default via a dataset.

Setup:

  • I have a DateTime parameter (pFirstDayOfMonth) with Time granularity: Day
  • Default value set using dynamic default from a dataset (CSV or SQL), which returns:
    • Start_Date: 2025-06-01(this is the value I want as default)
    • End_Date: 2025-06-30 (this is the value I want as default)
  • The dataset has a dummy group (dummyGroup = 'a'), and I’ve correctly mapped it in the dynamic default settings
    • However, on 1st July, the dashboard still shows 2025-07-01 as the parameter value, skipping June 30 data.
      The dashboard is expected to show data for the entire previous month, even when the current date moves into a new month.
      Tried:
  • Verifying dataset output
  • Re-mapping parameter to use End_Date instead of Start_Date
  • Re-adding the parameter control in the analysis
  • Confirmed dataset is returning the correct value (2025-06-30)

Issue:

Despite dynamic default being set, the parameter still defaults to start of the current month on July 1st instead of June 30.

Any advice on how to force the parameter to pick the start_date (or yesterday’s date) reliably on the 1st of each month would be appreciated.

2

Hey @Asfak

From what I understand, the data is returning accurately in your table but the parameter is not so when you use this parameter to filter a visual you are getting the wrong date range? Or did I miss something?

How are you using the parameter in your visuals?

3

Hello @Asfak

Do you still need help with this or were you able to solve it?

4

Hello @Asfak

This topic is being archived becuase it has been some time since we have heard from you.

If you still need help or have a new question please post a new topic at the top of the community so that its a priority for community experts.