KNOWLEDGE BASE

Error "Invalid Filter" When Filtering to Latest Date with Discrete ISO Week Date Field


Published: 14 Dec 2018
Last Modified Date: 13 May 2019

Issue

When using a date field with the date type as discrete ISO week, AND selecting the option "Filter to the latest date value when workbook is opened" the following error may occur:

Invalid Filter

Environment

  • Tableau Desktop 2018.2 - 2018.3

Resolution

Option 1
Upgrade to Tableau Desktop 2019.1 or a newer version. For more information, see Upgrade Tableau Desktop and  Tableau Desktop Downloads and Release Notes.

Option 2
If you are unable to upgrade to 2019.1 or newer, try the following:
  1. Set the field to Continuous
  2. Change the Date field to ISO week
  3. Change the Date field back to Discrete before applying the filter.
  4. Apply the filter; the error should no longer occur.

Cause

This behavior is related to a known issue with ID 853631 and was resolved in the 2019.1 release of Tableau Desktop.

Did this article resolve the issue?