5 Replies Latest reply on Oct 26, 2018 5:48 AM by Andrew Goldman

Set default filter based on a value from another filter

Ivan Mezev Oct 3, 2018 8:08 AM

Hello,

I have a dashboard with a view and two Single Value (dropdown) filters: Country and Investment type.

Is it possible when the user selects for example Poland the second filter automatically to change to "DGF" Investment type. When the user selects for example Germany the Investment type autimatically to change to "FTCC" investment type.

Is there a way to create an action between them or to link them somehow?

Have in mind that all the Investment type options are relevant values but i want only one of them to be the default one.

Thanks,

Ivan

1. Re: Set default filter based on a value from another filter

suman kumar Oct 3, 2018 8:20 AM (in response to Ivan Mezev)

Hi

yes, It is possible if this is in the data source.
You just need to click on filter option and select Only Relevant Value option.
apply this in both filter.
See below image.

Please mark correct and Helpful if it works for you.

Best
Suman
Like Show 0 Likes(0)

Actions
2. Re: Set default filter based on a value from another filter

Ivan Mezev Oct 3, 2018 9:16 AM (in response to suman kumar)

HI,

I know for this option but this is not what I need. I want to have a certain default investment type selected based on the selection in country.

Only relevant value is applied to the both filters already.
Like Show 0 Likes(0)

Actions
3. Re: Set default filter based on a value from another filter

suman kumar Oct 3, 2018 9:23 AM (in response to Ivan Mezev)

first apply filter or choose any investment type and country then save it. Now try to open it again.

I don't know if it will work or not.
Like Show 0 Likes(0)

Actions
4. Re: Set default filter based on a value from another filter

Ivan Mezev Oct 3, 2018 9:31 AM (in response to suman kumar)

This will work only for one country and one investment type. I have more than 10 countries and a lot of investment types
Like Show 0 Likes(0)

Actions
5. Re: Set default filter based on a value from another filter

Andrew Goldman Oct 26, 2018 5:48 AM (in response to Ivan Mezev)

Same issue I'm seeing here:

Auto-Select Multi-Select Quick Filter Values based on Single Dropdown Quick Filter Selection Above It - Possible?

Very curious to see if a good solution is found since Only Relevant Values doesn't make sense in this scenario
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

Set default filter based on a value from another filter

1. Re: Set default filter based on a value from another filter

2. Re: Set default filter based on a value from another filter

3. Re: Set default filter based on a value from another filter

4. Re: Set default filter based on a value from another filter

5. Re: Set default filter based on a value from another filter

Actions

More Like This