How to Create a Relevant Value Filter When Swapping Sheets in Tableau

Data

How to Create a Relevant Value Filter When Swapping Sheets in Tableau

Swapping sheets with parameters should be something you either learned in your intermediate Tableau Desktop training class or from a colleague. It is a nice technique, and I still enjoy teaching it to Tableau students who struggle to understand the difference between green and blue (discrete and continuous). From that perspective, swapping sheets on a dashboard is a freaking magic trick. If you are not sure what I am talking about, please read this description.

The Common Issue

In my consulting role, I was recently asked by a client to troubleshoot a problem associated with swapping sheets. I hope by describing my solution to the problem, I can save you some valuable time the moment you run into a similar problem. Use this dashboard as a reference:

The issue can be described as follows: The client has a dashboard with two worksheets on it. A parameter allows the user to swap from one sheet to another. In the example above, I would switch from A historic view to Campaign Distribution.

In addition, there are filters shown (formerly called quick filters) that allow users to filter across the two sheets. This works as long as the filters are set to show all values in the database. With the filter set to only show relevant values, you lose all drop-down values as soon as the sheet that initiated the filter is hidden by the parameter trick. This is not the type of thing an end user is happy about.

No items - womp womp

Not happy

The Solution

The solution to the problem is simple. Take a new empty worksheet, drop it in the dashboard and use that worksheet to drive the relevant values for the options of your filters. Step-by-step, I first create a new worksheet. Then you take the same filters that you had on the two swapping sheets and put them onto the Filter shelf of the new sheet. Apply these filters to the two worksheets you wanted to swap.

Apply to Worksheets > Selected Worksheets

Now drop the empty worksheet onto the dashboard. Find a way to hide it. In the example at hand, I use the title bar where I could squeeze the empty sheet in. Nobody noticed. Now remove all existing filters from the dashboard and set the filters from the empty sheet onto the same position with the same settings as before.

Remove filters from dashboard

The result is that you get a dashboard with swapping sheets and working relevant value filters. See the final product here:

The Kickstarter dataset can be found on Kaggle for those interested. If you have any questions, please drop a message in the comments below.

More About the Author

Justus Niemzok

Solutions Lead
InterWorks Trains the Next Generation of Data Analysts As alumni of Maastricht University, we love to go back and contribute to the learning path of students. Therefore, Raphael and I were ...
Digital Nomad: Who We Are, What We Do At InterWorks, we love the work we do. We love the culture we have. But sometimes, we’re not the best at explaining to our friends, ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072