KNOWLEDGE BASE

Cross-Database Date Filter Does not Apply to All Expected Worksheets


Published: 07 Dec 2017
Last Modified Date: 07 Dec 2017

Issue

When applying a date filter to "All Using Related Data Sources", then the filter does not apply to all expected worksheets.

Environment

  • Tableau Desktop
  • Multiple Data Sources

Resolution

Define the relationship for the date level of the date filter. For example, if the filter is MY(Date), then the relationship should also be defined on the MY date level.

For detailed directions on defining relationships see Step 1 of Filter Data Across Multiple Data Sources.

Cause

Date values must match exactly between data sources in order for a date filter to be applied to multiple data sources. If the date relationship is defined at the wrong level, then the date values will not match the filter.
Did this article resolve the issue?