Top Filters in Tableau

In this article, we will show you how to create Bottom or Top filters in Tableau with examples.

Before getting into this Tableau top filters demo, Please refer to Filters to understand the basic filtering techniques. For the bottom and top filters in the Tableau demo, we will use the data source we created in our previous article. Please visit the Data Labels in Reports article to understand the Data Source.

Top Filters in Tableau

First, Drag and Drop the Sales Amount Measures region to Columns Shelf and English Product Name from Dimension Region to Rows Shelf. By default, Tableau will generate the Bar Chart.

Top Filters in Tableau 1

Here, we are going to add a Tableau top filter condition on the English Product Name. So, please click on the down arrow beside the English Product Name present in the Row Shelf that will open the menu. Here, you have to select the Filter..option.

Top Filters in Tableau 2

Once you select the option, a new window is opened to create a filter.

Tableau Top 10 Filters By Field option

The following is the list of options available in this Tableau Top Filters section:

Top Filters in Tableau 3

First Dropdown List: By default, this will select the Top. But you can change the field to the Bottom by clicking the down arrow.

Top Filters in Tableau 4

Second Dropdown List: By default, this Tableau filter field filled with value 10 means Top 10. But you can change the value by clicking the down arrow. When you click that down arrow, it allows you to select or create a new Parameter.

Top Filters in Tableau 5

Third Dropdown List: By default, this will select the Measure value present in the record. But you can change the field by clicking the down arrow. When you click that down arrow, it displays the Measures and Dimensions present in the data source.

Top Filters in Tableau 6

Fourth Dropdown List: By default, this will select the Aggregate Function applied to the Measure value. But you can change the function by clicking the down arrow.

Top Filters in Tableau 7

Tableau Top 10 Filter Example

In this example, we use the Tableau Top 10 filter to select the top 10 records based on the Sum of the sales amount.

From the screenshot below, you can observe that we are selecting the By filed section. Next, we chose the Top, Sales Amount as the condition, and Sum as the Aggregate function. And lastly, we added 10 values in the text box.

Top Filters in Tableau 8

The below report displays the Top 10 records according to their Sum of Sales Amount. Or we can say, Top ten records based on their sales amount.

Top Filters in Tableau 9

Tableau Bottom 10 Filter

Here, in this example, we use the Tableau bottom 10 filters to select the bottom 12 records based on the Sum of the sales amount column.

For this Tableau bottom 10 filter example, let me change the Filed option from Top to Bottom and the integer value to 12

Top Filters in Tableau 10

The below report displays the bottom 12 records according to their Sum of Sales Amount. Or we can say, Least performing products.

Top Filters in Tableau 11

By formula

Here, you can write your own custom and more complex conditions as the Tableau Top Filter condition.

Filter By Formula 12

While you type any letter in that Top filter Text field, Tableau intelligence will display the list of available options, such as Field Name and function names.

Top 10 By Sales 13

From the screenshot below, you can observe that we had selected the By Formula section. Next, we added the SUM([SalesAmount]) code as the formula.

Top 10 by Sum of Sales Amount 14

The below report displays the Top 10 records according to their Sum of Sales Amount. Or we can say, Top ten records based on their sales Amount.

Top Filters in Tableau 15

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. Slicing Filters
  10. Keep and Exclude Filters
  11. Action Filters
  12. Parameters
  13. String Parameters