This is a filter which shows the relevant values (Spain provinces) based on another filter:
I would like to filter just the selected provinces. The problem is, since ‘Select all’ is marked, it shows every province in my dataset, instead of just the relevant ones.
I think that the problem is in the value = ‘Todo’ (equivalent to ‘All’ in english). If I uncheck a province, the value change from ‘Todo’ to a list including the marked provinces:
But if I select again the unmarked province, ‘Select all’ is automatically marked and the value changes from a list to ‘All’, including the non-relevant values.
How are you populating the list of values for the second filter? If you have something like country/city you can use the “Show only relevant values” for the second filter, which should give you a list of only the relevant values based on the first filter.
Here is a post that explains how to set up this kind of cascading filters.
I also found the same behaviour you found with the select all some time ago when manually entering a list of values for a filter, and I expected the Select All to just have a list of all values, but it looks like QuickSight just removes the filter altogether when the Select All is selected (or all the values are selected, which results in the select all being selected)
I hope you can workarround this with the cascading filters based on relevant values.
I was already using the cascading filter; I just did not know it was named that way.
Here is the issue: When I click on ‘Select all,’ it chooses every single province instead of the relevant ones using the cascading filters. Using an analogy from the post you provided: it transitions from +50 to 28 hospitals in the selectable dropdown filter. However, if I mark ‘Select all,’ I end up with those +50 hospitals selected instead of the intended 28.
