Hi Team, Requirement: Display data dynamically based on the selected Period Type parameter Day When the user selects Day in the Period Type parameter, the Order Date parameter should display all available dates. The most recent available date should be selected by default. Week When the user selects Week , the Order Date parameter should display only the Monday date of each available week (e.g., 27-Jul-2026, 20-Jul-2026, 13-Jul-2026). Upon selecting a week, the report should display data for the entire Monday-to-Sunday period corresponding to that week. Month When the user selects Month , the Order Date parameter should display all available months. The latest available month (e.g., Jul-2026) should be selected by default. Quarter When the user selects Quarter , the Order Date parameter should display all available quarters. The latest available quarter (e.g., 2026-Q3) should be selected by default. Custom Dates When the user selects Custom Dates , the following parameters should be displayed: Start Date End Date Report data should be filtered based on the chosen date range. Lifetime When the user selects Lifetime , all available data should be displayed without applying any date filters.

I have implemented the solution for day and week. Check the updated workbook attached.

You can handle this with a Period Type parameter and calculated fields using DATETRUNC for Day, Week, Month, and Quarter. For Week, truncate to Monday and filter the data from Monday through Sunday. Use separate Start/End Date parameters for Custom Dates, and bypass date filtering for Lifetime. Dynamic parameter values can be used to default to the latest available period.

Jul 29, 3:07 AM

When the user selects another parameter, the parameter needs to be updated.

Hi Team,

Requirement: Display data dynamically based on the selected Period Type parameter

Day
- When the user selects Day in the Period Type parameter, the Order Date parameter should display all available dates.
- The most recent available date should be selected by default.
Week
- When the user selects Week, the Order Date parameter should display only the Monday date of each available week (e.g., 27-Jul-2026, 20-Jul-2026, 13-Jul-2026).
- Upon selecting a week, the report should display data for the entire Monday-to-Sunday period corresponding to that week.
Month
- When the user selects Month, the Order Date parameter should display all available months.
- The latest available month (e.g., Jul-2026) should be selected by default.
Quarter
- When the user selects Quarter, the Order Date parameter should display all available quarters.
- The latest available quarter (e.g., 2026-Q3) should be selected by default.
Custom Dates
- When the user selects Custom Dates, the following parameters should be displayed:
  - Start Date
  - End Date
- Report data should be filtered based on the chosen date range.
Lifetime
- When the user selects Lifetime, all available data should be displayed without applying any date filters.
#Tableau Agent