KNOWLEDGE BASE

All Values Showing in Relevant Filter When (All) is Selected in Cross Datasource Filter


Published: 31 Jul 2018
Last Modified Date: 03 Aug 2018

Issue

When using a cross data source filter as a context filter, and a filter from the primary data source is set to show only relevant values, then unchecking and rechecking (All) in the cross data source filter causes all values to show in the other filter.

Environment

  • Tableau Desktop
  • Cross data source filters

Resolution

As a workaround, add a condition to the cross data source filter:
  1. Right-click the field on the Filter shelf and select Edit Filter...
  2. In the Filter dialog, do the following and click OK:
    1. Navigate to the Condition tab
    2. Select By formula
    3. Type in TRUE

Cause

This is a known issue currently under investigation.
Did this article resolve the issue?