How to Remove Unwanted Values (e.g. Nulls) from Tableau Filters

By: Eric Parker

Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can also sign up for a Tableau Office Hour to work with him directly!

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 the video below to see this solution in action.

Build a Selected vs. Comparison Date Period Filter in Tableau

Preparing Survey Data in Tableau Desktop - Webinar Recording

0