Top N filters in Tableau - Step-by-Step Guide

Introduction

Top N filters help you show only the top items in your data, like top 5 products by sales. This makes dashboards clearer by focusing on the most important data points.

When you want to display the top 10 customers by revenue on a sales dashboard.

When you need to show the top 3 performing stores in a region without clutter.

When your report should highlight the top 5 products by profit margin.

When you want to limit a chart to the top 20 employees by sales volume.

When you want to compare only the top 7 cities by number of orders.

Steps

Step 1: Drag the dimension you want to filter (e.g., Product Name) to the Filters shelf

- Filters shelf

A Filter dialog box opens showing the dimension values

Step 2: Select the 'Top' tab in the Filter dialog box

- Filter dialog box

The Top tab shows options to filter by top or bottom values

Step 3: Choose 'By Field' and set it to show the top N items by a measure (e.g., Top 5 by Sales)

- Top tab in Filter dialog box

The filter will limit the view to the top N items based on the selected measure

Step 4: Click OK to apply the filter

- Filter dialog box

The worksheet updates to show only the top N items

Step 5: Optional: Show the filter control on the worksheet to let users change N

- Filters shelf, right-click the filter and select 'Show Filter'

A filter control appears on the worksheet allowing dynamic selection of top N

Before vs After

Before

Worksheet shows all 50 products with their sales values

After

Worksheet shows only the top 5 products with the highest sales values

Settings Reference

Top N filter

📍 Filter dialog box > Top tab

To limit the data to the top or bottom N items based on a measure

Default: No filter (all items shown)

Measure selection

📍 Filter dialog box > Top tab > By Field dropdown

To choose which measure determines the top N ranking

Default: First measure in the list

Show Filter control

📍 Filters shelf, right-click filter > Show Filter

To allow users to interactively change the top N value

Default: Hidden

Common Mistakes

Selecting the wrong measure for the Top N filter

The filter will rank items based on the wrong data, showing unexpected results

Always verify the measure used in the Top tab matches the intended metric (e.g., Sales, Profit)

Not showing the filter control when users need to change N

Users cannot adjust the number of top items dynamically, limiting interactivity

Right-click the filter on the Filters shelf and select 'Show Filter' to add a control

Applying Top N filter on a dimension with too few unique values

The filter may not reduce data or behave unexpectedly if N exceeds available items

Check the number of unique dimension values before setting N to avoid confusion

Summary

Top N filters limit data to the highest or lowest N items based on a measure.

They help focus dashboards on key data points and reduce clutter.

Remember to pick the correct measure and show filter controls for user flexibility.