EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Context Filter in Tableau

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » Tableau Tutorial » Context Filter in Tableau

Context Filter in Tableau

Introduction to Context Filter in Tableau

Filtering is used to access all the data in data source independently. Filtering will help the users to give an insight into the data and provide the search independently. For example – if we want to filter the department according to the employee, at that time we can filter out employees belonging to a different department. This will be helpful for the small database. If we have a data of multinational companies and who has more than 20k employee, then Context Filter in Tableau is the right choice to use in the tableau. We need to add a context filter to the respective dimension. We can create and remove the context filter from the tableau.

How to Create the Context Filter in Tableau?

We are going to create a context filter for the category of the order table.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

  1. We are going to add a sample superstore database. (we can add different database from tableau site)
  2. Open sample superstore into tableau public or
  3. Drag orders table into the tableau datasheet.
  4. Drag sales measure to columns and sub-category dimension to

As we can see in the below image Bar chart is created because tableau by default creates the bar chart.

Context Filter in Tableau1

  1. We will add the filter to the sub-category (Will filter out Top 10 or 20 as per the sales).
  2. Click on down arrow of the sub-category, Filter window will get
  3. Click on

You can see in the below image, there are more options for the filter. Show filter will display various types of filters available in the tableau such as condition or TOP. If we click on the remove sub-category will be removed from the rows.

filter

When we click on the filter, the filter window will get open. Look at the image below.

Context Filter in Tableau3

We have four options available to the Filter, such as given below with meaning.

  • General – we can select all the list or select one or two of our choice, here comes with we can custom the
  • Wildcard – we can match the values from given datasets such as contains, starts with, ends with and exactly. It contains within the dataset. starts with for example – starts with a, b or etc. ends with for example – ends with a, b, etc. exactly for example- exactly as power or any
  • Condition – we can define condition means statement with min and max
  • Top – Top 10 or 20, etc value and Bottom value 10 or 20, etc. we will have this with Min, Max,

After clicking on the filter -> go to Top and select Top value.

1. Top by 10 and sales as SUM.

2. Sub-category will be displayed by the top 10 sales and it gets added to filter.

Context Filter in Tableau4

3. We have a drag category dimension to Filters shelf.

(when we drag category to filters shelf, a new window will open, and we can select all the category or category of our choice from given choices)

Popular Course in this category
Tableau Training (4 Courses, 6+ Projects)4 Online Courses | 6 Hands-on Projects | 39+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (6,121 ratings)
Course Price

View Course

Related Courses
Business Intelligence Training (12 Courses, 6+ Projects)Data Visualization Training (15 Courses, 5+ Projects)

Context Filter in Tableau5

4. We have selected category as Furniture and Technology.

You can see that only 7 records got displayed because furniture and technology product has only 7 sub-categories present. The first sub-category filter applied and values are fetched by TOP 10 sales and sub-category gets displayed as per the furniture and technology category.

category.

5. Click on the category name and select Add to context.

The category filter name is gets changed to context filter. You can observe now first context filter gets applied then the result is shown y TOP 10 value as per the sub- category.

shown y TOP

How to remove the context filter from the tableau?

Removing context is an easy task to do but remember that once you remove the context filter, data will be shown as it was before. Data will be shown by the TOP 10 sub-category.

  1. Click on the context filter in the Filters shelf (you can see the grey color dimension is context filter)
  2. Click on remove from

Category

Conclusion

We have learned about filters and context filters. Filters will help users will filter out the dataset as per our choice and when it comes to context filter, it will show us the filtering based on the large database and will provide more accurate result and this will avoid repetitive work. When we apply the context filter, it gets executed in the tableau then the rest of the filters if present in the tableau will get executed. The data source is accessed simultaneously.

Recommended Articles

This is a guide to Context Filter in Tableau. Here we discuss introduction to Context Filter in Tableau, how to create it with explanation. You can also go through our other related articles to learn more –

  1. Tableau Context Filter
  2. Tableau Calculated Field
  3. Map Layers in Tableau
  4. How to Window Sum Tableau?
  5. Tableau Order of Operations | How to Order?
  6. Tableau User Group | How to Create?

All in One Data Science Bundle (360+ Courses, 50+ projects)

360+ Online Courses

50+ projects

1500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary 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 Chart Types
    • Donut Chart in Tableau
    • 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
    • Tableau Date 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 Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Reporting
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • 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

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • 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

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

EDUCBA Login

Forgot Password?

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
Book Your One Instructor : One Learner Free Class

Let’s Get Started

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

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
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

Special Offer - Tableau Certification Course Learn More