![](https://ynteractive.com/wp-content/uploads/2023/02/c8bad1_4c8a69edb1644c939e544893bfc47f9fmv2.png)
Step 1:
Build a dual axis chart using [Date], [Quantity], and [Sales]. The result will be a combined bar and line chart.
![](https://ynteractive.com/wp-content/uploads/2023/02/c8bad1_0afe085176f34042a60b2d4e70cf1a9cmv2.png)
Step 2:
Create a string parameter with these options. year, quarter, month. Make sure they are not capitalized. You can set an alias with a capital letter for display purposes.
![](https://ynteractive.com/wp-content/uploads/2023/02/c8bad1_d65d7206657049de97659c48bd3dbffamv2.png)
Step 3:
Create this calculated field to serve as the date that is controlled by the parameter.
DATE(DATETRUNC([Date Aggregation], [Order Date]))
![](https://ynteractive.com/wp-content/uploads/2023/02/c8bad1_492cf5705dc24c72bfe46ecd0fa7a3a0mv2.png)
Step 4:
Add [New Date] to the column shelf as “Exact Date”. Right click your parameter, and select “Show Parameter.
![](https://ynteractive.com/wp-content/uploads/2023/02/c8bad1_6a8b50ac513d471f8bc7cd89d3e032a5mv2.png)