Loading

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

Date de publication: Mar 3, 2025
Tâche

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

Étapes
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.
Ressources supplémentaires
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".
Numéro d’article de la base de connaissances

001458358

Pièces jointes

Only relevant values.twbx

37 KB

 
Chargement
Salesforce Help | Article