So one way to do this is, as you say to use parameters (filters won't work as you want as they will only display the range of the data within the filter).
In the attached I've added the 2 parameters, and set up a filter so they affect the data shown. The next trick is to create a Reference Line off each of the 2 parameters, this will force the axis to that range. In the attached I've shown the reference lines, but you can set the line to none, in your real world example, and so hide them from view.
Hope that helps
Force Chart Axis.twbx 20.7 KB
You need join your data to a calendar table as shown below
and then create a calculation field and build the view like below
A sample workbook attached for your reference.
Hope this helps
Book1_v10.2.twbx 14.8 KB
It does work!!! Tableau is such a powerful tool.
I am curious about other way to get same result. Could you kindly explain more
I'd appreciate your help
1 of 1 people found this helpful
So I think the 2 methods I can think have both been covered (my one with parameters and ZZ's one to add all dates to the data). When we select a continuous date as a filter, Tableau let's us select a range, even if there isn't data (exactly) at each extent of that range. This means that any chart will only show the data available on a chart (and not that the chart axis is determined by that range), so the parameter (with fake reference line) or exploding the data to have a row for every date are the ways to get this behavior.