Post1

Show/Hide Filter in Tableau

Posted by Poliparthi Maheswararao

Despite the presence of several quick filters, legends, and other links, we may sometimes require more space to display data in the Tableau Dashboard. There’s, however, a restriction on the size and space of the Tableau Dashboard visualization. Hiding filter container for quick filters, legends and other links helps overcome the situation. If you are also facing similar challenge, this blog has all the information you may require for an interactive and impressive tableau dashboard visualization. The post is a walk through on how you can show or hide a dashboard filter using different buttons. Let’s get started.

Dashboard Setup

There are primarily three types of tableau dashboard visualizations you can have –
• Dashboard with Filter Container
• Dashboard without Filter Container
• Two sheets that can be used a filter

Original Dashboard comes with Filter Container. For our convenience and your understanding, we duplicated this dashboard and removed all the filters and legends. So, now we have two dashboards. The below images depict both the dashboards: With Filter Container and Without Filter Container.

Figure 1: Dashboard with Filter container

Figure 2: Dashboard without Filter Container

Show and Hide Action

The key action for showing and hiding data columns is to add close and toggle tab to dashboard with and without Filter Container. We take two separate sheets, each for close and toggle button, as example for filter that redirects us to another dashboard bringing the hide and unhide for Filter Container into effect.

Figure 3: Sheet with close button

Figure 4: Sheet with toggle button

Now, we add a sheet for close button on the Filter Container on the left pane. In this sheet the close button is easily visible on the top-left corner of the Filter Container.

Figure 5: Dashboard with filter container and close button

Similarly, we added a sheet for toggle button on the left pane, with the toggle button also visible on top-left corner of Dashboard without Filter container.

Figure 6: Dashboard without filter container and toggle button

These additions give us two dashboards: one with Filter Container having close button and other without Filter Container having toggle button.

Action Filter for Dashboard Redirection

Moving between dashboards can be cumbersome. To simplify the process of switching between Dashboards, we add an action filter each on close and toggle buttons, which redirects us to the required Dashboard.
The following images display action filters for dashboard redirection.
The first image shows a Dashboard with Filter Container view, where we have created an action on the close sheet, targeting to the Dashboard without Filter on selecting the sheet.

Figure 7: Action for close tab

The next image depicts Dashboard without Filter Container view, where we have created an action on the toggle sheet, targeting to the Dashboard with Filter on selecting the sheet.

Figure 8: Action for toggle tab

Thanks to these action filters, when we click the close button in Dashboard with Filter, we are targeted to Dashboard without Filter and when we will click on the toggle button, we are targeted to Dashboard with Filter.

With this we finish our explanation of hiding and unhiding the Filter Container in Tableau Dashboard. Try adding the close and toggle sheets to the dashboard along with the action filter and let us know about your experience in the comments below. Thank you for reading the post, we’ll soon be back with another interesting topic.

Until Next Time,

TechBlog!!

Related Posts

  • Dynamic Pie Charts in TableauDynamic Pie Charts in Tableau

    Tableau is arguably one of the most preferred data visualization tools in the Business Intelligence Industry. It converts raw data into easily understandable formats, enabling marketers, researchers, business owners, and…

  • Tableau – Sets and Hierarchy functionalityTableau – Sets and Hierarchy functionality

    Business Intelligence and visual data analysis are core requirements of today’s businesses. While there are numerous tools with such capabilities, Tableau is among the most preferred BI tool for its…

  • Removing Default ABC Placeholder in TableauRemoving Default ABC Placeholder in Tableau

    Tableau, a multipurpose tool gives users the freedom to exercise their creativity when developing visually rich reporting. Among its various liberties of building new views, altering the default formats of…

  • Formatting Individual Columns in Tableau (Dual-Axis Crosstabs)Formatting Individual Columns in Tableau (Dual-Axis Crosstabs)

    A simple step by step explanation with screenshots attached! Tableau can only format based off one value.  For example, you can have a chart that displays Sales and Profit, but…

  • Introduction to Microservices

    Traditional development methodologies encourage the ‘monolithic’ approach to application development. Building a single application that does everything required has been the modus operandi for a while. However, with the rise…

  • Understanding Teradata Wallet

    Teradata Wallet is a facility for storage of sensitive/secret information, such as Teradata Database user passwords. Users are able to save and retrieve items by using this facility. Teradata wallet…

Leave a Reply

Your email address will not be published. Required fields are marked *