Mastering Filters in Tableau: A Guide to the Different Types of Filters

If you want to become a Tableau expert, you need to master filters! Filters are an essential tool for narrowing down your data to focus on the most relevant information. There are several types of filters in Tableau, each with its own syntax and use cases. In this post, I'll introduce you to the different types of filters in Tableau and show you how to use them with examples.

Extract filters: Extract filters allow you to filter data in an extract instead of filtering the data source. When you create an extract filter, Tableau filters the data that is included in the extract, which can help improve the performance of your workbook.

To apply an Extract filter, first, create an extract of your data source. Then, right-click on the extract in the Data pane and select "Extract Filters". You can then select the field you want to filter on and set the filter criteria.

Data Source filters: These filters allow you to limit the data that is included in your Tableau workbook at the data source level. When you create a data source filter, Tableau retrieves only the data that meets the filter criteria from the data source. Data Source filters can improve the performance of your workbook by reducing the amount of data that needs to be loaded into memory.

• To apply a Data Source filter, go to the Data Source tab and click on the sheet where you want to apply the filter. Then, select the data source you want to filter and click on the "Add" button in the Data Source Filters area. You can then select the field you want to filter on and set the filter criteria.

Context Filters: Context filters allow you to filter data based on a specific context, such as a subset of your data that you want to analyze separately from the rest. To apply a context filter in Tableau, you can follow these steps:

• Drag the dimension you want to filter on to the Filters shelf.
• Right-click on the dimension and select "Add to Context".
• In the filter dialog box, set the conditions you want to use to filter your data.
• For example, you might want to analyze your sales data for a specific region, but also want to exclude certain products from the analysis. You can use a context filter to accomplish this.

Dimension Filters: Dimension filters allow you to filter data based on a specific dimension, such as region, product, or category. To apply a dimension filter in Tableau, you can follow these steps:

• Drag the dimension you want to filter on to the Filters shelf.
• In the filter dialog box, select the values you want to include or exclude from your view.

For example, you might want to filter your sales data to show only the data for a specific region, like the Southeast. You can use a dimension filter to accomplish this.

Measure Filters: Measure filters allow you to filter data based on a specific measure, such as sales, profit, or quantity. To apply a measure filter in Tableau, you can follow these steps:

• Drag the measure you want to filter on to the Filters shelf.
• In the filter dialog box, set the conditions you want to use to filter your data.

For example, you might want to filter your sales data to show only the data for sales that exceed a certain amount, like $1,000. You can use a measure filter to accomplish this.

Top and Bottom Filters: Top and bottom filters allow you to filter data based on the top or bottom values for a specific dimension or measure. To apply a top or bottom filter in Tableau, you can follow these steps:

• Drag the dimension or measure you want to filter on to the Rows or Columns shelf.
• Right-click on the dimension or measure, and select "Filter".
• In the filter dialog box, select "Top" or "Bottom" from the drop-down menu.
• Set the number of values you want to include in your view.

For example, you might want to filter your sales data to show only the top 10 products by sales volume. You can use a top filter to accomplish this.

Relative Date Filters: Relative date filters allow you to filter data based on a relative date range, such as the last 7 days, last month, or last quarter. To apply a relative date filter in Tableau, you can follow these steps:

• Drag the date field you want to filter on to the Filters shelf.
• In the filter dialog box, select "Relative Date".
• Set the date range you want to filter on.

For example, you might want to filter your sales data to show only the data from the last quarter. You can use a relative date filter to accomplish this.

It's important to note that the order in which you apply filters is important, as it can impact the results you see in your data. In general, the order in which you should apply filters is:

1. Data Source filters
2. Extract filters
3. Context filters
4. Dimension filters
5. Measure filters
6. Table Calculation filters

By applying filters in this order, you ensure that the filters are applied in the most efficient way and that you are seeing the most accurate data in your visualization.

In conclusion, filters are a powerful feature in Tableau that allow you to focus on the most relevant information in your data. By using the different types of filters available in Tableau, you can create custom views that provide insights into your data that might otherwise be hidden.