EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Filters in Tableau
Secondary Sidebar
Tableau Tutorial
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Filters in Tableau

By Priya PedamkarPriya Pedamkar

Filters in Tableau

Introduction to Filters in Tableau

Filters in Tableau will assist us to visualize data efficiently and quickly. Depending upon the nature of data and the requirement primarily we have 6 types of tableau filters. Each filter is designed to work on a specific situation like when the column contains numerical values or strings? is it a measure or a dimension? Etc. Applying these filters are very straightforward and simple, and can be done in seconds.

Imagine you have a spreadsheet that contains 10000 rows of data and you need only 10% of this data for your job. Wouldn’t it be time-saving if you work on only this 10% for data instead of working on the whole sheet?

In most of cases, the answer would be ‘Yes’. Therefore, refining data plays a vital role in Data Visualization.

Tableau a Data Visualization tool and also, one of the market leaders in the year 2019 provides an ability to organize and view data according to our requirements with the help of Various filter options available in Tableau.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Types of Filters in Tableau

Below are the different types of Filters in Tableau:

  • Dimension Filter (Filter Shelf)
  • Measure Filter (Filter Shelf)
  • Quick Filter
  • Context Filter
  • Extract Filter (Data Source)
  • Data Source Filters

1. Dimension Filter

Dimension filter is applied to non-aggregate columns like Region, Customer Name, Country, etc. In this filter option, we filter data according to categories which we require for our task.

NOTE: For the demonstration purpose we are using the sample bank data with the Dimensions: Customer ID, Date Joined, Region Gender, Job Classification, and Surname. Measures are AGE and Balance. In the below picture our objective is to filter data of Job Classification VS Balance by Region.

How to Use Dimension Filter?

To apply Dimension, drag the Dimension on which you want to apply the filter (in our case Region) to the Filter Shelf as shown in the picture in RED. After dragging the Measure filter window will open which will have four tabs as follows:

  • General
  • Wildcard
  • Condition
  • Top
1. General

In this tab, we can include/exclude the fields on which we want to apply filter. Tableau also provided options like ALL, NONE, Custom Value list and USE ALL which helps us to easily select our required filter columns even if we have a large number of columns.

Filters in Tableau - General

2. Wildcard

We can use a wildcard filter to include/exclude the fields which start, ends, contains or exactly matches the value in which we enter the text box. For Example, if you need records of customers whose name is James then you can use the ‘contains’ option as shown in the picture below.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,408 ratings)

Filters in Tableau - Wildcard

3. Condition

We can use condition filters in two ways as follows:

  • By Field
  • By Formula

By Field

Here we can select a field from the available dimensions and measures. Then we can select the different aggregate functions from the drop-down, such as SUM, AVERAGE, COUNT, etc. and also chose the condition whether it should be <, > <=, >= or =. We can also provide a range of Maximum and Minimum values.

By Formula

Here we can specify fields that we want to filter by typing the corresponding formula in the formula box. For Example, In the below picture we are filtering our records whose balance is less than 5000.

condition

4. Top/Bottom

In this tab, we can visualize Top “N” or Bottom “N” records based on the filter “by field or by the formula” similar to Condition tab. Here “N” can be any number greater than zero. With the help of this option, we can get Top/Bottom 5,3 or 10, etc. records as per our requirement.

2. Measure Filter

Measure filter is applied on aggregate columns like Age and Balance. In this filter option, we filter data according to aggregate functions that we require for our task.

How to Apply Measure Filter?

To apply measure filter simply drag one of the measures in the filter shelf as shown below in RED. Then the Filter Field window will open then select aggregate function according to your requirement.

NOTE: For the demonstration purpose we are applying the filter on the measure AGE and selecting “All values.”

After selecting the aggregate function (All Values in our case) we can select how we want to apply filter condition from the 4 tabs as follows.

Measure

  • Range of values

Here we need to provide the start and end value of the range which we want to view in our result. (In the example below, we can select any age between 15 and 64. If we want to find the result for age between 30 and 40 then we need to specify 30 as start value and 40 and end value.)

  • At least

Here we need to provide only the start point of our range.

  • At most

Here we need to provide only the endpoint of our range.

  • Special

Here we can choose between null, non-null and All values

tableau Measure

Measure Filter 3

3. Quick Filter

Quick filter or custom filter is mainly used in cases where one needs to quickly visualize the filter data with a single and multiple value list.

How to apply Quick Filter?

  • To Apply Quick filter, you need to have a measure or a dimension in the filter shelf. Then you need to right-click on the field (in our case, it’s REGION) and check “Show Filter”.
  • Then you will find a new checkbox in the worksheet, you can visualize the data according to different categories (in our case, it’s England, Scotland, etc.)

Quick Filter 1

  • You can also select the type of quick filter by clicking on the down arrow in the checkbox and choose between single, multiple and wildcard match values as shown in the picture on the right.

Quick Filter 2

4. Context Filter

  • A Context filter is a filter option that can create a separate group of data out of the original data source and compute the selections made in the worksheet.
  • Once the context filter is applied it appears in gray color as shown in the picture.
  • Context Filter can be handy in the cases where fixed Top or Bottom records are required for different categorical fields.

Context Filter

Context

5. Extract and Data Source Filters

Extract and Data Source Filter are the filters which are usually applied before moving to the worksheet. These filters are useful as using these we can filter out the unnecessary data at the beginning itself.

The main difference between extract and Data Source filters is the filter result of the data source filter is visible instantly however the filter result of the extract is visible only after moving to the worksheet tab (Sheet1).

How to apply Extract Filter?

To apply this filter first select the connection type as Extract then click on edit after which you need to click on add and then select a field, and depending on what type of field you select (a measure or a dimension) a filter window will open. The rest of the things are similar to Dimension or Measure filter.

How to apply Data Source Filter?

To apply this filter, you need to click on Add (highlighted in green) then you need to add fields on which you want to apply the filter, Rest of the things are similar to Dimension or Measure filter.

 Data Source

Conclusion

Tableau has provided various options to filter and restrict the source data as per our requirements. These filter options help us to visualize only the required information which saves our time, processing power, memory, and efforts. Quick filter and its Menu types can help us to visualize data very quickly and efficiently. Measure and Dimension filters are like the base of Filter options in Tableau. Here we enough option to filter any type of data as per our requirements.

Recommended Articles

This is a guide to Filters in Tableau. Here we discuss the Types of Filters in Tableau and How to Apply the Filters step by step with the Screenshots. You may also look at the following article to learn more –

  1. Tableau Alternatives
  2. What is Tableau?
  3. Data Mining Software
  4. PHP Filters | How to validate User Input using Various Filters?
Popular Course in this category
Tableau Training (8 Courses, 8+ Projects)
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more