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
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture12.png)
Step 2: Define a Start Date on the calendar (e.g. Sunday the Week of the Selected Day)
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture13.png)
Step 3: Define an End Date on the calendar
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture14.png)
Step 4: Create a calculated field for the Date Filter
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture15.png)
Step 5: Put Month(FilterDate) on Filter and Columns
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture-plus_1.png)
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture16-1024x253.png)
Step 6: Put Year(FilterDate) on Columns, so Jan next year does not come before Dec this year
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture17.png)
Step 7: Set Sunday as the Default Week Start Day
Right click on Data Source, go to Date Properties,
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/03/Capture18.png)