How to Build a Reset Filters Button in Tableau
Vložit
- čas přidán 3. 08. 2024
- Connect with us:
•Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
•Book an hour to work with Ollie: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
I was recently working on a project for a client that had a lot of dimension filters - anywhere from 5 to 10 on each dashboard. This allowed us to drill down to the level of information we needed!
But a problem arose when we wanted to reset the filters and select new values. How could we do that? Did we really need to reset each filter individually? That’s so inefficient!
We decided to build a “Reset All Filters” button on each dashboard. When you click on it, it reverts all the filters to their default state so you can quickly make your new selections!
How do we build one?
•Build a worksheet which will drive the action
•Add the worksheet to a dashboard
•Apply dashboard filtering actions
Want to learn how? Check out the video!
Resources:
•Example Tableau Workbook: public.tableau.com/views/Rese...
•Worksheet Filter Options in Tableau: onenumber.biz/blog-1/2021/9/5...
Chapters:
0:00 Intro
1:14 Building the Button
6:55 Troubleshooting Date Fields
Need help building one of these for your project? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
This guy actually knows what he's doing. So many people just go through the motions, this guy actually understands.
Thank you so much! We're glad it sounds like this helped!
This is super helpful and practical! Thanks for sharing!
We're glad it was helpful! You're welcome!
great video and wonderful tutorial, thanks for sharing. :)
Great to hear, you are welcome!
Thank you)
Thank you too!
Thank you for sharing. Is there a way to reset the values of parameter filters in Tableau?
You're welcome! Not with a creation like this but we recommend checking out the Reset Views button: czcams.com/video/V9zT2WFkahE/video.html&ab_channel=OneNumber-TableauExperts
Thank you for this! It was very helpful! I have the reset button created and working, but when I click it the first time, it does nothing and is highlighted blue. When I click it the second time, it resets the filters and the highlighting is removed. Any ideas?
Hey! The blue highlighter is annoying... it's there because Tableau sees the reset button as a worksheet, rather than a button. So here's a way around that! www.flerlagetwins.com/2020/07/14-use-cases-for-transparent-shapes.html?m=1
Will this also work for when you are using sheets on a dashboard as a filter for the rest of the dashboard? I can't get it to reset those selections.
Hi John! Thanks for checking this video out. Unfortunately, this approach won't clear worksheet selections. However, we've got a video dropping on Wednesday about the "Reset View" button that should help with your question!
Great video, thank you!
What to do in a situations where I have a filter that flips between two graphs (e.g.: sales by week/ by period). I have Parameter (by week/ by period) Worksheet selection filter, and fields that go into it. I've tried everything but none of it resets this type of filter. Is there any way to do it?
I'd appreciate any pointers, thanks!
Hey - you won't be able to reset the parameter selection using the reset filters button. Then, the reset filters button works best with dimensions. Measures can be buggy... so if you're trying to reset the measures using this, it might be choppy! But your end-users could use the reset dashboard button if they're viewing it on Tableau Cloud.
Thanks so much for this video. I was wondering, Is there a way to auto undo the selection of the sheet after you've clicked it, for a better UX? :)
I think if you use a transparent hex code color, it won't show the blue highlight after being selected. That doesn't really change the fact that it is selected, but at least it looks a little better: www.flerlagetwins.com/2021/10/introducing-transparent-color-hex-code.html
Otherwise, I'd probably direct people to the Revert/Reset button on Tableau Server and Tableau Public.
@@onenumbertableau Thanks so much for the response I’ll have a look.
I noticed another way is to use custom shapes. For some reason it doesn’t show the ugly blue highlight when using custom shapes.
@@Syzemic Nice! Hopefully one of these solutions works!
I've been watching and enjoying all of your videos. This is a great feature, however, it doesn't seem to work on Wildcard filters. It clears everything else, but doesn't touch the wildcard filter. Any solution to clear ALL filters (including the wildcard filter)? Thanks!
Hey! The only way you can reset a wildcard filter with a button is with an extension. They're trickier because you want to specify that a blank value goes into the wildcard filter. It's technically not resetting it.
So that's a shortcoming of this method I'm afraid! Tableau doesn't have a native way to do this, so we're limited by the available features.
@@onenumbertableau Thank you for the response! I appreciate the additional information. I found an extension for a filter reset, but it also was limited and unable to reset the wildcard filter. I'll keep looking and keep watching your videos. Keep up the great work!
@@jodyrohde6938Thank you, you're welcome!
If we have multiple dashboards do I need to create several reset filter buttons or can I reuse the same one?
Hey! You could use the same button. Be sure to select the right sheets on the right dashboards! But, you should be totally fine :)
Hi, want to divide single bar in 4 equal half such as 25%, 50%, 75% and 100%. And display count of measures falling in each part. Is it possible to make such viz? ( the size of all 4 parts should remain constant, only the Text value of measure will change)
Hi Shilpa, thanks for reaching out. I'm not clear on what you're trying to accomplish. Do you have an example you can share?
Maybe something like a summary tile? onenumber.biz/blog-1/2021/6/10/how-to-create-summary-tiles-for-tableau-dashboards
Followed your steps but it says "Missing fields on reset filter" on dashboard action setup
Hey! As far as we've seen, this could be because there are multiple fields that you could select (like multiple date fields). Alternatively, it could just be because there are fields in the view that aren't linked to the reset filter!
WAs facing the same issue. The solution, incase anyone needs it is to go to a sheet fight click filters that say all using this data source and then click on selected worksheets. You need to deselect the 'reset all filters' sheet from there. It should work. :)
@@Syzemicwow. you save my life. great thanks!
Hi there, I don't understand why you left "Keep filtered values" selected in the "Target Sheets" box. Don't you want to toggle to "Show all values" to reset the filters? Perhaps I'm misunderstanding the purpose of the "Clearing the selection will:" options. Can you clarify? Thanks!
Target Sheets
Clearing the selection will:
-Keep filtered values
-Show all values
-Exclude all values
Hey! Good question! It's because the filtering is happening when we click the button and not afterwards. So after we deselect the button (click on the button again), we want Tableau to keep all the restored values we've just specified. You could probably select "show all values" and it would still work.
But that's the short answer!
@@onenumbertableau Thank you! I love you guys and make watching your weekly blog post videos a priority!
@@wendyware3064 You are welcome, thank you so much for the support!