I have a dashboard which has a date parameter. Requirement is to show previous 13 calendar months in the axis from the selected date in parameter and the trend will show data for the months which are available in source . In the data source we have Mar19,Jun19,Sep19,Dec19,Jan20,Feb20,Mar20,Apr20,May20 in date column. When Apr 20 is selected in Month parameter , axis has to show previous 13 calendar months from Apr 20 i.e; Apr19 to Apr 20. Since Apr19 is not in the data source axis is showing as below.
Is there any way to show previous 13months in the axis from the selected date even if there is no data in the source? Values in the chart will be shown as a trend wherever data is applicable.
I am happy to share more details. Many thanks for your help.
Thanks for your reply. Missing values is enabled. It will show the missing values in between start and end values in the axis.
My question is different than this. In the data source I have May 2019, Jul 2019, Oct 2019,Jan 2020,Mar 2020. When Mar 2020 is selected in parameter I want to show previous 13 calendar months in the axis i.e Apr19 to Mar 2020 in the axis and the trend will show for data which is available for the months.
If you see Apr 2019 is not there in the datasource so axis will show only 11 months starting from May 2019 to Mar 2020. Requirement is axis will always show the previous 13 months from the selected month no matter if month is available in the source.
Ex: If Mar 2020 is selected axis will show Apr 2019 to Mar 2020 ( calendar months not the data months)
If Jan 2020 is selected axis will show Feb 2019 to Jan 2020
