Measure filters in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a measure filter in Tableau?

A measure filter in Tableau is a filter that limits data based on the values of a measure (numeric data), such as sales or profit, allowing you to focus on specific ranges or thresholds.

beginner

How do measure filters differ from dimension filters in Tableau?

Measure filters filter data based on numeric values (like sales amounts), while dimension filters filter data based on categories or labels (like product names or regions).

intermediate

Can you apply a measure filter before or after aggregation in Tableau? Explain.

Measure filters in Tableau are applied after aggregation by default, meaning they filter the summarized data (like total sales per region). To filter before aggregation, you use context filters or calculated fields.

beginner

What is the effect of using a measure filter on a dashboard visualization?

Using a measure filter changes the data shown by removing values outside the filter range, making the visualization focus on specific numeric ranges, which helps highlight important trends or outliers.

beginner

How can you create a measure filter in Tableau?

You drag a measure to the Filters shelf, then choose the filter type (range, at least, at most, etc.) and set the numeric limits to filter the data accordingly.

What type of data does a measure filter in Tableau work with?

A Numeric values like sales or profit

B Text categories like product names

C Date fields only

D Geographic locations

Measure filters work with numeric data such as sales or profit values.

When is a measure filter applied in Tableau's data processing?

A Before data connection

B Before aggregation

C After aggregation

D During data import

Measure filters are applied after aggregation, filtering summarized data.

Which shelf do you use to add a measure filter in Tableau?

A Columns shelf

B Filters shelf

C Rows shelf

D Pages shelf

You add measure filters by dragging the measure to the Filters shelf.

What happens if you set a measure filter to show sales greater than 1000?

A Only data points with sales above 1000 are shown

B All data points are shown

C Only sales below 1000 are shown

D Sales data is hidden

The filter limits the data to sales values greater than 1000.

Which of these is NOT a typical measure filter option in Tableau?

A Range of values

B At least (minimum value)

C Top N values

D Alphabetical order

Alphabetical order applies to dimension filters, not measure filters.

Explain how measure filters affect the data shown in a Tableau visualization.

Think about how filtering sales numbers changes the chart.

Describe the steps to create a measure filter in Tableau.

Start with the measure and end with setting the filter range.