KNOWLEDGE BASE

Filtering Out The Date When Using A Continuous Measure Shows Jan 1 1900 In The Axis And Not An Empty Value


Published: 22 May 2020
Last Modified Date: 22 May 2020

Issue

Filtering out the date when using a continuous measure shows Jan 1 1900 in the axis and not an empty value

Environment

  • Tableau Desktop

Resolution

1. Right click the axis -> Edit axis
2. Change the range to fixed start and Automatic end
3. Change the value of fixed start to starting value for the data set or any desired valid date 

Cause

When the date is filtered out, the axis for the date measure shows DATE(0) as default which is directed to the value 1/1/1900

Additional Information

Date cannot be programmed to have an empty value representation in axis
Did this article resolve the issue?