How to Remove Unwanted Values (Nulls) From Filters in Tableau
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- About Me:
About:
Hi! I'm Eric with OneNumber. Thanks for checking out our channel. We appreciate the support! We love to help people with their Tableau problems. Feel free to comment, reach out directly, or check out our upcoming classes/events if you want to take Tableau to the next level (www.eventbrite....
Description:
Let me guess, you have a value (maybe a null) displaying in a Tableau filter and you want it to go away? You don’t want to leave it just sitting there because it’s ugly and your users are insatiably curious. You know if you leave it they are going to select it and you’re going to have to answer questions about what this “null” value means and why it’s a filter option.
You can leverage Tableau’s order of operations to your advantage. By using a set, you can remove the unwanted value(s) one step before dimension filters so your user never sees it as an option! Be careful though, once that value is removed from the worksheet, all associated data will be removed as well.
Check out this video to see this approach in action!
Need help removing unwanted values from filters? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Thanks! Really helpful :)
You're welcome, glad to hear this helped!
appreciate it so much i literally spent hours searching for solutions
Oh no! I'm sorry it took so long to find this but I'm glad to hear it will help!
you the number one hero in tableau 😍
Wow, thank you! We're glad this helped.
Very helpful. Thank you!
You're welcome!
Thanks
You are welcome!
epic solution!
Thank you!
Thanks Man. ❤️
You are welcome!
Thank you sooooo much!!!!!
You are welcome! Glad to hear this helped!
Many thanks Eric 👍
You got it!
thank you so mucchhh 😁😍
You are most welcome!
Thank you!
life saver
Great to hear!
Really Helpful.
Glad to hear it, thank you!
AWESOME!
We're glad you found it helpful!
hi, when I creat set, the Create Set dialog box did not show up and a date set was created immediately.
Hi Justin! Thanks for letting me know. When you created the set, did you right-click on the Date field in the Data Pane?
@@onenumbertableau Hi, thanks for getting back. I looked around for some solutions online and the issue seems to be due to I am using tableau online instead of tableau desktop. I also found a workaround which is to drag the created set into the Marks - Details section, which will allow you to show set, then drag it back out to filter.
@@justinzhou7245 Good sleuthing. I'm glad you found a solution!
How can I remove a value from the filter and keep it in the sheet (you remove it from the sheet). I want a specific value to always be ON without the user having the option to remove it from the filter
In this example, do users need to be able to multi-select the options in the filter or could a single select filter work? If a single select filter could work, you could get creative with a parameter tied to a calculation that filters the sheet.
what if we wanted to show the Null value results in the view but not in the filter. Ultimately I want the Null results to always be toggled ON and not allow it to be toggled OFF by the user. So in this case, I want only the years to show up in the filter options and the results from the Null values to always be present
This is a hack but I guess you could lump it in with something else. For example....
IFNULL([State],"New York")
Then you use the original [State] field in your worksheet but use the IFNULL calculation on filters.
It will get funky if someone actually removes New York from the view because it will remove the nulls as well, but it might work.
Hello,
I have a problem, when I remove null with the way you suggested it affects all my dashboard, is there a way to remove the null value without it affecting all the data?
Thanks
Could you try sorting the null value to the bottom of your list for a filter?