Maintaining Fixed Axis Based on Data Source Date Range When Filtering

Published: 16 Sep 2016
Last Modified Date: 20 Dec 2017


How to filter a view and ensure that the axis will be fixed on the desired range despite filtering.


Tableau Desktop


  1. Create a calculated field called Min Date: {MIN(Date)} 
  2. Create a calculated field called Max Date: {MAX(Date)} 
  3. Drag Min and Max Date onto Detail.
  4. Right-click on the Date Axis and Select Add Reference Line.
  5. Set using Min Date , No Label, No Line.
  6. Repeat Step 3 & 4 for Max Date.
Did this article resolve the issue?