Reset Relevant Values Only Dropdown Filter to None instead of (not existing value)

KNOWLEDGE BASE

Reset Relevant Values Only Dropdown Filter to None instead of (not existing value)

Published: 09 Apr 2019
Last Modified Date: 18 Mar 2020

Issue

For example there are two single value (drop down) filters, "Investor" and "Currency". "Currency" is dependent on "Investor" with "Only Relevant Values" option. As the result of changing the "Investor" filter to another value, no "Investor" record exists. In that case the "Investor" filter value is automatically display as the selected value with enclosed in parentheses. Is there any way to reset it to "(no items)"?

Environment

Tableau Desktop

Resolution

A possible workaround is to change single value (drop down) to single value (list) . If the selected value does not exist in the filter with the "Only Relevant Value" option as a result of changing the dependent filter, no filter value is selected. It is easier to understand that no data exists than single value(drop down) .