Slicing Filters in Tableau

Slicing Filters in Tableau termed as 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 Source, 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 as the Slicing Filter. In this article, we will show how to create Slicing Filters in Tableau 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 to refer Filters to understand the basic filter techniques.

Create Slicing Filters in Tableau

In this example, we want to demonstrate the Slicing filters in Tableau. For this first, Drag and Drop the English Country Region Name from Country Hierarchy present in the Dimension Region to 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 on 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 are selecting Black and Multi colors. I suggest you to refer the Filters on Dimensions article to understand the properties in the following window.

Slicing Filters in Tableau 3

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

Slicing Filters in Tableau 4