Hi and thanks so much for sharing this, very useful. I have a similar use case you may be able to help. let's suppose that I want to hide Central from the filter selection but at the same time I want to keep Central always in the results. Using a duplicate of the filter to EXCLUDE is an easy one but how to manage to always INCLUDE an option in the results without giving the user the option to select/deselect it in the filter options? Thanks to anybody who has an idea 🤝 I already tried using SET . This is indeed excluding the wished option from the filter options but at the same time it removes it from the view.
Quick filters that only show relevant values. To use an example of Category and Subcategory filters where subcategory is set to only show relevant values. A user selects Furniture as the category and Office Chairs as the subcategory. But if they now go back to select Office Supplies as the category the viz will go blank. Why? Because Office Chairs is not a valid subcategory of Office Supplies. Any solution is there?
Yes, that’s a problem. One way is to create a clear filter button, you can see how it’s done here: Reset All Filters - Tableau Tips 3 th-cam.com/video/M6nqrGe3COo/w-d-xo.html
Great tip 👏👏
Exactly what I was looking for. Thanks!!
Thank you very much! Helped a lot!
Hi and thanks so much for sharing this, very useful. I have a similar use case you may be able to help. let's suppose that I want to hide Central from the filter selection but at the same time I want to keep Central always in the results. Using a duplicate of the filter to EXCLUDE is an easy one but how to manage to always INCLUDE an option in the results without giving the user the option to select/deselect it in the filter options? Thanks to anybody who has an idea 🤝 I already tried using SET . This is indeed excluding the wished option from the filter options but at the same time it removes it from the view.
Quick filters that only show relevant values. To use an example of Category and Subcategory filters where subcategory is set to only show relevant values. A user selects Furniture as the category and Office Chairs as the subcategory. But if they now go back to select Office Supplies as the category the viz will go blank. Why? Because Office Chairs is not a valid subcategory of Office Supplies. Any solution is there?
Yes, that’s a problem. One way is to create a clear filter button, you can see how it’s done here: Reset All Filters - Tableau Tips 3
th-cam.com/video/M6nqrGe3COo/w-d-xo.html