To filter marks from the view, select a single mark (data point) or click and drag in the view to select For example, if you have a scatter plot with outliers, you can exclude them from the view so you can better focus on the rest of the data. You can filter individual data points (marks), or a selection of data points from your view. Select to keep or exclude data points in your view For details on the Filter dialog box, see Drag dimensions, measures, and date fields to the Filters shelf and Filter categorical data (dimensions). The settings on each of these tabs are additive starting with the General tab what you set on each tab will affect the filter results on each tab to the right. Note: When you drag a discrete dimension to the Filters shelf, the Filter dialog box offers four tabs for filtering: General, Wildcard, Condition, and Top. To learn more, see Tableau's Order of Operations (Link opens in a new window). Filters are executed in the following order:įilters on dimensions (whether on the Filters shelf or in filter cards in the view)įilters on measures (whether on the Filters shelf or in filter cards in the view) Tableau performs actions on your view in a very specific order this is called the Order of Operations. Filtering Order of Operationsīefore you begin filtering data in Tableau, it's important to understand the order in which Tableau executes filters in your workbook. Use your (Link opens in a new window) account to sign in. Watch a Video: To see related concepts demonstrated in Tableau, watch these free training videos: Ways to Filter (Link opens in a new window) (2 minutes), Where Tableau Filters (Link opens in a new window) (4 minutes), Using the Filter Shelf (Link opens in a new window) (7 minutes), Interactive Filters (Link opens in a new window) (4 minutes), and Additional filtering topics (Link opens in a new window) (7 minutes). It also describes how you can display interactive filters in the view, and format filters in the view. This article describes the many ways you can filter data from your view. Filtering is an essential part of analyzing data.

Disable links in excel 2003 spreadsheet