KNOWLEDGE BASE

Maintaining Fixed Axis Based on Data Source Date Range When Filtering


Published: 16 Sep 2016
Last Modified Date: 19 Sep 2016

Question

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

Environment

Tableau Desktop

Answer

  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?