In Tableau, many filter types are quickly available using the right-click option on the measure and dimension. These filters have enough functionality to solve most of the everyday filtering needs. These filters are known as Quick filters.

The below screenshot shows how the quick filters are accessed:

The given below table lists the various quick filters and their uses in Tableau.

Filter Name	Purpose
Single Value (List)	It selects only one value at a time in the list.
Single Value (Dropdown)	It selects a single value in a drop-down list.
Multiple Values (List)	It can select one or more values in a list.
Multiple Values (Dropdown)	It selects one or more values in the drop-down list.
Multiple Values (Custom List)	It selects and searches for one or more values.
Single Value (Slider)	It drags a horizontal slider for selecting a single value.
Wildcard Match	It selects values containing the specified characters.

For example, consider a data source such as Sample-Superstore, to apply some quick filters. First,

Choose the sub-category field as the row shelf and sales as the column shelf that produces a horizontal bar chart.
Drag the sub-category field to the filters pane. Apply wildcard filtering using the expression p* to select all subcategory names starting with “p“.

The below screenshot shows the result after applying this filter where only the sub-categories starting with “p” are displayed:

How to Clear the Filter

After the analysis is completed by applying the filter, you can remove it by using the clear filter option.

First, go to the Filter Pane.
And, right-click on the field and choose Clear Filter option as shown in the below screenshot.

After clearing filter from the filter pane, the worksheet looks like the below screenshot:

Tableau Context Filters

All filters that you arrange in Tableau are computed independently. And, each filter accesses all rows in your data source without view to other filters.

You can arrange one or more categorical filters as context filters for the view. And context filter can work as an independent filter. Any other filters that you arrange are defined as dependent filters because they process only the data that passes through the context filter.

Context filter is created because of the following reasons:

Improve Performance: If you want to set a lot of filters or have a significant data source, then queries start running slowly. In such case, you can set one or more context filters to improve performance.
Create a Dependent Numerical or Top N Filter: You can set a context filter to include the data of interest only, and arrange a numerical or a top N filter.

Create a Context Filter

To create a context filter, first select Add to Context from the context menu of an existing categorical filter. The context is computed once the view is generated. All other filters are then calculated relative to the context. Context filters are:

Appeared on the top of the filters pane.
Identified by the gray color on the filters pane.
Not rearranged on the filters pane.

For example, consider the data source such as Sample-superstore, find the top 10 Subcategory of products for the category called Furniture. There are the following steps.

Step1: Drag the Sub-Category field to the Rows shelf and Sales field to the Columns Shelf.

Step2: And, choose the horizontal bar chart from the “Show Me” tab.

Step3: Again, drag the Sub-Category to the Filters shelf. You get the chart shown in the below screenshot.

Step4: Right-click on the Sub-Category field in the filter shelf and click on “Edit Filter ” option then go the ” Top ” tab in the pop-up window.

Step5: And, choose the “By field ” option. From the next drop-down, choose the option Top 10 by Sales Sum as shown in the below screenshot.

Step6: Drag the Category field to the filter shelf. Right-click on the Category field to edit and choose Furniture from the list. It shows three subcategories of products as a result shown in below screenshot.

Step7: Now, adding the context filter, Right-click on the Category: Furniture filter and select the “Add to Context” option.

Step8: Above all steps produce the final result that shows the subcategory of products from the category Furniture.

So, this brings us to the end of blog. This Tecklearn ‘Tableau Quick and Context Filters’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/tableau-desktop/

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau

Why Tableau
Tableau Product Platforms
Tableau Architecture
Tableau Interface

Data Connection with Tableau Desktop

Features of Tableau Desktop
Connect to data from File and Database
Types of Connections
Data Blending
Joins and Unions
Tableau Desktop User Interface
Basic project: Create a workbook and publish it on Tableau Online

Basic Visual Analytics

Visual Analytics
Basic Charts: Bar Chart, Line Chart, and Pie Chart
Hierarchies
Data Granularity
Highlighting
Sorting
Filtering
Grouping
Sets

Advanced Visual Analytics

Parameters
Tool tips
Trend lines
Reference lines
Forecasting
Clustering

Calculations in Tableau

Calculated Fields
Numeric, String, Data, Logical, Addressing and Partitioning
Table Calculations

Level of Detail (LOD’s) Calculations

Advanced Charts in Tableau

Box and Whisker’s Plot
Bullet Chart
Bar in Bar Chart
Gantt Chart
Waterfall Chart
Pareto Chart
Control Chart
Funnel Chart
Bump Chart

Parameters

What If Scenarios
Parameter in CF (KPI control)
Parameter in Filter (Top N)
Parameter in reference line

Dashboards and Stories

Introduction to Dashboards
The Dashboard Interface
Dashboard Objects
Building a Dashboard
Dashboard Layouts and Formatting
Interactive Dashboards with actions
Designing Dashboards for devices
Story Points

Data Security in Tableau

Optimizations tips and tricks

Interacting with Tableau Server

Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

541