Loading

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

Дата публикации: Mar 3, 2025
Задача

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

Действия
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.
Дополнительные ресурсы
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".
Номер статьи базы знаний

001458358

Вложения

Only relevant values.twbx

37 KB

 
Загрузка
Salesforce Help | Article