3 Replies Latest reply on Jan 24, 2019 8:57 AM by maneesh.gaddam

Filter changing to "All" after selecting another filter

jonathan.almenar Jan 24, 2019 8:24 AM

Hi,

I have 4 filters (See below) set and they are all dependent on the filter on top of each filter (I selected "Only Relevant Values"). When I select my third filter (Post), my second filter (Country) automatically changes to "All". However, that second filter is still functioning (Filtering by country), but now it shows "All" instead of the selection I picked previously. Moreover, if I make a selection on my fourth filter (Position Type) My third filter then changes to "All" automatically as well. The only filter that does not change to "All" is the first one (Region).

Any ideas what could be causing this problem?

1. Re: Filter changing to "All" after selecting another filter

maneesh.gaddam Jan 24, 2019 8:24 AM (in response to jonathan.almenar)

Jonathan,

As you picked to show 'only relevant values', When you make a selection in the 'Third filter', there is only 1 value tied to it in the 2nd filter, so it is automatically filters to that selection in filter 2(because of relevant values) and filter shows 'All'.

Same thing happening with the 3rd and 4th filters. You have either train the users to use filters 1,2,3,4 in that order or don't show the relevant values (at least for 1 & 2).
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Filter changing to "All" after selecting another filter

jonathan.almenar Jan 24, 2019 8:42 AM (in response to maneesh.gaddam)

Thank you for your answer Maneesh. Is there another way to make my filters dependent on other filter without using "Only Relevant Values"?
Like Show 0 Likes(0)

Actions
3. Re: Filter changing to "All" after selecting another filter

maneesh.gaddam Jan 24, 2019 8:57 AM (in response to jonathan.almenar)

I don't know if it solves the issue but try make=ing them context filters. You can read more about them here.
Improve View Performance with Context Filters - Tableau

Basically it creates and temp table for the selection and other filters can only show values for that context filter selection. So, if you make Region filter context, for other filters, play around with selecting 'All values in Hierarchy' or 'All values in Hierarchy and context' etc, see if you can get what you're looking for.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Filter changing to "All" after selecting another filter

1. Re: Filter changing to "All" after selecting another filter

2. Re: Filter changing to "All" after selecting another filter

3. Re: Filter changing to "All" after selecting another filter

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account