Filtering data - Amazon QuickSight

Filtering data

You can use filters to refine the data displayed in a visual or insight. By default, a filter applies only to the item that was selected when the filter was created. You can set the scope of a filter to one or more visualizations or insights. You can also change the scope of a filter after you create it. Each filter can apply to multiple datasets if the field has the same name and type in each dataset.

Each filter applies only to a single field or calculation. Filters are applied to the data before any aggregate functions that you specify. If you create multiple filters, all top-level filters apply together using AND. If you group filters by adding them inside a top-level filter, the filters in the group apply using OR.

Amazon QuickSight applies all of the enabled filters to the field. For example, suppose that there is one filter of state = WA and another filter of sales >= 500. In this case, the dataset only contains records that meet both of those criteria. If you disable one of these, only one filter applies. Take care that multiple filters applied to the same field aren't mutually exclusive.

Amazon QuickSight uses filters to focus on or exclude a visual element representing a particular value. For more information about focusing on a visual element, see Focusing on visual elements. For more information about excluding a visual element, see Excluding visual elements.