Why can't I "Show Relevant Values Only"?

Hello! I want my control filter to only show relevant values based on a different filter. I have both filters on the sheet and the text is still grayed out. Any ideas why?


Thanks!
Kristin

@kakervall If you have more than 1 filter all tied with 1 dataset then this option should be enabled.

1 Like

Hey @neelay! Thanks for your info. I’m wondering if it is something with the dataset. Maybe you can help me… I have made filters that function across visuals built on multiple datasets before. These filter controls are tied to a parameter and a specific field in the dataset. Because the same field is found in the multiple datasets represented in the dashboard, the filters have worked. At least I think this is why it has worked.

In this instance I have a filter (Filter 1) that is applied to a visual built on dataset A. Filter 1 is tied to field A that exists in dataset A. Field A is not represented in the other datasets. However, my issue is that I want a second filter (Filter 2) to control what values appear in Filter 1. Filter 2 is based on a field B that exists in every dataset included in the dashboard.

Thoughts? Thanks for your help!

@kakervall I believe, this is not possible for now.
if all of your filters are for 1 dataset, then you can configure them to change based on the selected value of the 1 or many filters.

1 Like

I see. Thanks for the info!

1 Like