KNOWLEDGE BASE

Date Quick Filter Not Showing Date Values In Tableau Server / Tableau Online


Published: 13 Mar 2020
Last Modified Date: 16 Mar 2020

Issue

After publishing the dashboard to Tableau Online or Tableau Server from Tableau Desktop, the date filter is not rendered as expected in Tableau Online or Tableau Server and the selected date values do not appear.

An example below is the field "Ship Date" which does not display the date range in the filter

User-added image

Environment

  • Tableau Online
  • Tableau Server

Resolution

Option 1 
  1. Open the workbook in Tableau Desktop and go to the view that contains the filter
  2. Select the field that the filter is using and right click the field
  3. Select "Default Properties -> Date Format"
  4. If Custom format is selected please check the format values entered and ensure it is a valid format as per our Online Help
Option 2 

Alternatively choose another date format such as "Automatic" and save the change and republish to Tableau Server / Tableau Online 

Cause

When a Date Format of type "Custom" is chosen if there is no information provided in the format field, the dates will not display. To avoid this issue please supply a format for the Custom format or alternatively use another format.

User-added image
Did this article resolve the issue?