Slicing Filters in Tableau

Slicing Filters in Tableau are termed Calculation Filters or Slicers. These are the dimension filters, and we have to apply them to the dimensions field. The behavior of these filters is different for Multi-Dimensional Data Sources compared to the Relational data source.

Tableau Slicing Filter: If we place a dimension on the Filter Shelf, and that Dimension is not present in any other shelf (independent from Rows and Columns), then we can call it the Slicing Filter. In this article, we will show how to create Slicing Filters with an example.

For this Tableau slicing filters demonstration, we are going to use the data source that we created in our previous article. So, please visit Data Labels in Reports article to understand the Tableau Data Source. Before getting into this, I suggest you refer to Filters to understand the basic filter techniques.

Create Slicing Filters in Tableau

In this example, we want to demonstrate the Slicing filters. For this, first, Drag and Drop the English Country Region Name from Country Hierarchy present in the Dimension Region to the Rows Shelf and Sales Amount Measures region to Columns Shelf. By default, it will generate the Bar Chart.

Crosstab report for Slicing 1

Next, we want to apply filter conditions to the Colors Dimension. And it is not a member of any existing shelf (Marks, Rows, Columns, and Pages). So, drag and drop the Color from Dimension Region to Filters Shelf.

Slicing Filters in Tableau 2

Once you drop the Color to Filters Shelf, a new window called Filter will open. Here, we select Black and Multi colors to create Slicing Filters in Tableau.

I suggest you refer to the Filters on Dimensions article to understand the properties in the following window.

Slicing Filters in Tableau 3

From the screenshot below, you can observe that the report displays the Sales amount of all the state province names present in the country, whose Color is Black or Multi.

Slicing Filters in Tableau 4

The following is the list of remaining filters.

  1. Conditional Filters
  2. Context Filters
  3. Data Source Filters
  4. Extract Filters
  5. Filters on Dimensions
  6. Filters on Measures
  7. Quick Filters
  8. Selection Filter
  9. Top and Bottom Filters