2 of 2 people found this helpful
What if you tried making a single filter? You are just wanting to select one city, state reference and the postal code that goes with it?
You can replace the 3 filters with the new filter, and swap it to Single Value (Dropdown)
You will still have to type in the state, city .. but its one less step to worry about.
Just a thought!
Thanks for your solution. It's quite close to what I want, but I still want the state as separate filter, can I just remove the [state] from your code and create a state quick filter, apply the new filter (cal field) use show only relevant value?
Update: I tried to put state as a separate filter, the same issue occurred: when you change a new state, second filter (City+zip) will show last selection and ends up with a blank view
Hey even i'm facing this exactly same scenario and not found any solution . Solution suggested by @Joshua doesn't seem an appropriate solution. Kindly Help if any one can
What you can do is create a sheet for each filter you need i.e. State, City, and Postal Code.
Then through use of dashboard actions and some formatting you can get it to work like you want.
This is just one way to do it where a user selects for the hierarchy top/down:
After they navigate to the level of granularity required the chart will display as needed
They can go back and make any change they need to in any of the above filters.
9.1 workbook attached.
Cascading Quick Filters.twbx 1.3 MB