Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Tableau Filters

by suresh

Tableau Filters are used to restrict the data as per the client requirements. For example, we can exclude a region from the display, or we can display the top 10 performing records or low performing records using Tableau Filters. Before we start our example, It is essential to understand the Order of the Operations in which Tableau will execute the filters in our workbook. And the order would be:

  1. Extract Filters
  2. Data Source Filters
  3. Context Filters
  4. Filters on Dimensions
  5. Filters on Measures

In this article, we will show you how to create basic Tableau filters with example?. For this filters demo, we created two Hierarchies that represent the Country and Products. The below screenshot will show you the dimensions, and measures preview

Basic Tableau FIlters 1

Creating Tableau Filters

First, Drag and Drop the City Name from Dimension Region to Rows Shelf, and Sales Amount Measures region to Columns Shelf. By default, tableau will generate the Bar Chart, as shown below. Please remember, We have 269 Rows in our Tableau Report. Also visit Hierarchies and Data Labels in Tableau Reports article to understand the Tableau Data Source.

Basic Tableau Filters 2

Approach 1 to create Filters in Tableau

Tableau allows you to select the individual data points or a group of data points from the report. Once you picked the data points, you will get two options called Keep Only, and Exclude. Selecting either of the two means you are using the Filters indeed.

For example, if you observe the below screenshot, we are selecting some random 16 Cities from the bar chart. Next, we are using Keep only option. It means we are using the Tableau filter stating that Cities with the selected names should be displayed.

Basic Tableau Filters 3

As you can see, the report is displaying the records that we selected in the previous step. And most importantly, City dimension appeared at Filters Shelf.

Basic Tableau Filters 4

Approach 2 to create Tableau Filters

In this Tableau Filters example, We will use the Exclude Option. Here, we are selecting the first 96 Cities from the bar chart. Next, we are using the Exclude option. It means we are using the filter stating that Cities with the selected names should restrict from the display.

Basic Tableau Filters 5

You can observe that the tableau Filter report is displaying the cities starting with E.

Basic Tableau Filters 6

Though the above examples are enough to understand the basic filters in Tableau. I want to provide two more samples using the Tableau Maps. It might be useful for further reference.

Creating Filters in Tableau Maps

Drag and Drop the Sales Amount Measures region to Columns Shelf, and City Name from Dimension Region to Rows Shelf. By default, Tableau will generate the Bar Chart. So, please change it to Map using Show Me Shelf. As you can see, the Tableau Map is stating that there are 128 Unknown regions.

Basic Tableau Filters 7

Double click on it, will open the following window with multiple options. It is an entirely different topic, and we will discuss the possibilities in the Maps section. For now, we are choosing the second option (filter data). It means, we are applying the filters on the Map, and insisting the Map not to show those 128 regions.

Basic Tableau Filters 8

Now you can see the Map that excluded those 128 regions. It also called as filtering map data in Tableau.

Basic Tableau Filters 9

Create Tableau Filters using Exclude Option

We are selecting the data points from the Europe Region from the Map. Next, we are using the Exclude option. It means we are using the filter stating that, Sales Amount with that Region should restrict from the display.

Basic Tableau Filters 10

Now you can see the map without the European data.

Basic Tableau Filters 11

Create Tableau Filters using Keep Only Option

We are selecting the data points from the United States Region from the Map. Next, we are using Keep Only option. It means we are using the conditional filter stating that, Sales Amount with the United States Region should only display.

Basic Tableau Filters 12

The below screenshot will show the Tableau filter Map.

Basic Tableau Filters 13

Placed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions

Copyright © 2021· All Rights Reserved.
About | Contact | Privacy Policy