Tableau – Measure Filter

The measures are the fields that are aggregated like sum, average, median, etc. The values that are chosen from measure fields for adding to filters are called Measure filters.  To apply it, we will drag a measure from the list of measures fields from the data plane to the filter pane or right-click on a particular measure and select ‘Show Filter’.

Let’s see how can we create the Measure filter. Follow the steps to create it. (Using Sample Superstore)

  • Connect to Sample Superstore in Tableau.
  • Click on Sheet 1 and Create a Simple visualization (Here we have Sales of products).

This image shows the Sum of sales of all the subcategories divided in Categories

  • From the Measure field, we will drag a field to the filter pane. (Here we will have Sales as our Filter).

Here in the image we added the Sum of Sales to filter shelf to create a measure filter

  • Here as we added the filter, the filter provided four options i.e. Range of values, At least, At most, and Special. We can pick up any of the four options as preferred to select the right data.

In a range of values, we can adjust the values which means the user can adjust the range between the maximum & minimum. Another option is At least, where we can select the Minimum value of the measure as per the need. At most allows selecting the maximum value of the measure as per the need.

As we click on ‘OK’ the measured field will the added as a Measure Filter.

Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.

Established in 2020, Lets Viz Technologies provides a full range of high-quality data analysis and data visualization services. We are also an authorized Zoho Partner.

 

Contact

WeWork Berger Delhi One, C-001/A2, Sector 16B, Noida, Uttar Pradesh 201301

0124-502-5592
info@lets-viz.com

We are Social

Trust Pilot Reviews