Tableau – Top Filters

Top filters in Tableau allow you to filter data to show only the top N values based on a specific measure or dimension. This feature is useful when you want to focus on the most important or relevant data.

Before moving further, we’ve prepared a video tutorial on what are Top Filters in Tableau:

Top Filters in Tableau

The Top Filter is used to get, let us say the sub-category of products with top 5 or 10 sales. Let us create a new sheet and name it Top Filter in the same Amit_Tableau_Filters.twb Tableau Workbook.

First, drag the Measure Sales to the Columns shelf, and Dimension Sub-Category to the Rows shelf. After dragging, the horizontal bar chart will be visible as shown below:

1. Drag the fields and it created a bar chart in Tableau

Right-click the Sub-Category and click Filter:

2. Right click Sub Category and select Filter in Tableau

Go to the Top tab on the Filter [Sub-Category] window.

Click the drop-down, and select the option By field. Keep it to the Top and the value to 5 and rest as it is. i.e., keep the rest, Sales, and Sum dropdown as it is, and click OK. This will give us the sub-category of products with top 5 sales.

3. Select the TOP tab and filter Sum of Sales in Tableau

Now, after clicking OK above, the bar chart displays a sub-category of products with top 5 sales:

4. Top Filter implemented in Tableau


If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.


For Videos, Join Our YouTube Channel: Join Now


Read More:

Tableau - Conditional Filters
Tableau - Wildcard Filter
Studyopedia Editorial Staff
contact@studyopedia.com

We work to create programming tutorials for all.

No Comments

Post A Comment

Discover more from Studyopedia

Subscribe now to keep reading and get access to the full archive.

Continue reading