KNOWLEDGE BASE

How to Show "Only Relevant Values" In Filter When Using Data Blend


Published: 08 Jun 2021
Last Modified Date: 22 Jun 2021

Question

When using Data Blend, and add a field from the Secondary data source, there is no option as "Only relevant values" in the filter.

User-added image

However, if you use the field from the same data source, the "Only Relevant Values" could be set.
User-added image

Environment

  • Tableau Desktop

Answer

Workaround:

Option 1:
Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values.
Please check the attached workbook for details.


User-added image

Option 2:
Join tables that are in the same data source, instead of blending them.

Additional Information

When the published data sources are blended, it is impossible to set the relationship. 
In this situation, please consider setting the relationship of the original data sources and published it to Tableau Server.

The steps are as follows:
  1. In Tableau Desktop, relate the data sources in a relationship.
  2. Publish the merged data source to Tableau Server
  3. Connect to this published data source in Tableau Desktop.
  4. Add the field to [Filter] and set it to "Only Relevant Values".
Did this article resolve the issue?