Sometimes the space on the dashboard is limited, let’s see how do we make a 12-week dynamic Calendar.

Step 1: Create a Date Parameter for users to select the start date on the calendar

Step 2: Define a Start Date on the calendar (e.g. Sunday the Week of the Selected Day)

Step 3: Define an End Date on the calendar

Step 4: Create a calculated field for the Date Filter

Step 5: Put Month(FilterDate) on Filter and Columns

Step 6: Put Year(FilterDate) on Columns, so Jan next year does not come before Dec this year

Step 7: Set Sunday as the Default Week Start Day

Right click on Data Source, go to Date Properties,