How to Create Context Filter in Tableau

How to Create Context Filter in Tableau

2 mins read288 Views Comment
Vikram
Vikram Singh
Assistant Manager - Content
Updated on Apr 25, 2022 06:23 IST

In this article, we will discuss how to create context filter in tableau briefly with the help of example.

2022_04_CONTEXT-FILTER.jpg

Introduction

In this article, we will discuss How to create a context filter in Tableau.

Filters are an essential part of the data visualization to make the dataset clean and organized on pre-defined conditions to analyze the data set.

Let’s discuss the Context Filter in Tableau in complete detail.

Recommended online courses

Best-suited Tableau courses for you

Learn Tableau with these high-rated online courses

β‚Ή39.54 K
2 hours
– / –
45 hours
– / –
2 hours
Free
11 hours
Free
21 hours
Free
26 hours
Free
19 hours
Free
3 hours
Free
11 hours

Table of Content

Context Filter

  • Use to improve performance of views, filters, and queries run on data source.
  • It helps apply a relevant, actionable context to the entire data analysis in the tableau.
  • It gets applied before any other filters used in the worksheet
  • Context Filter is an independent filter, and all other filters will be applied to the data that is fetched by the context filter
  • A context filter is created to improve performance and to create a dependent numerical or top N filter
  • To add a context filter, click on Add to Context on the contextual menu of any existing categorical filter.

Let’s understand how to create a context filter with an example.

  • Find the top 10 postal codes for the category called furniture.

To know more about Tableau, click here.

Steps to Create Context Filter

  • Connect a file (here, we will use sample superstore data)
  • Drag the sales to row and postal code to the column shelf

  • Drag the postal code to filter shelf

  • You will get the window shown in the below screenshot

  • Choose by field option
  • From the drop-down choose the option Top 10 by sales sum (as shown below in the screenshot)

  • Drag the category field to the filter shelf, and you will get the window shown in below screenshot
    • It will show three categories, 
      • choose furniture

  • Right-click on the category in the filter shelf and select Add to Context

  • The final result shows the postal codes of products from the furniture category.

To know more about, tableau course and certification.

Conclusion

In this article, we have discussed how to create context filter in tableau with examples.

Hope this article will help you in your data analyst journey.

This article is a part of a complete tutorial on Tableau, focusing on Tableau certified data analysts and tableau desktop specialists. 

Connecting data in Tableau
Connecting data in Tableau
In this article, we discussed connecting data in tableau, how to connect files and servers to a tableau with steps on how to connect excel files, how to connect MySQL...read more
Types of Charts in Tableau
Types of Charts in Tableau
In this article, we will discuss different types of charts in Tableau: Bar, Line, Gantt, Histogram, Tree, Box and Whisker Plot.In this article, we will discuss different types of charts...read more
Dimension and Measure in Tableau
Dimension and Measure in Tableau
Tableau supports seven different data types and it tableau automatically assigns a data type and role to each column.
In this article, we will discuss one of the important concepts...read more
About the Author
author-image
Vikram Singh
Assistant Manager - Content

Vikram has a Postgraduate degree in Applied Mathematics, with a keen interest in Data Science and Machine Learning. He has experience of 2+ years in content creation in Mathematics, Statistics, Data Science, and Mac... Read Full Bio