As per my understanding this is difficult to plot the missing months which are beyond the minimum date of the source. Tableau generate the axis based on the minimum and maximum date from your source and if any date is missing in between these range then using missing values option tableau populate the axis. This is how tableau deals with date field.

Now as per your requirement, we can always get the last 12 months data in the view only concern is to generate the axis for months which are not in the data beyond the minimum month. You need to do scaffolding with another source which contains all the month dates then you can join and generate the axis. That's the only solution which comes in my mind.

If you can manage to get the entry of missing months in your source then use below logic to get the latest 12 months data.

Hi mahfooj, thanks a lot for the reply. For missing months beyond minimum date, we tried entering all the dates in excel and used that excel as a secondary/primary datasource with datablending but this approach has not worked