Adding filters - Amazon QuickSight

Adding filters

You can add filters to a dataset or an analysis. Use the following procedures to learn how.

Adding filters to datasets

Use the following procedure to add filters to datasets.

To add a filter to a dataset
  1. From the QuickSight start page, choose Datasets.

    
								This is an image of the datasets option on the left pane when you first open QuickSight.
  2. Choose the dataset that you want, and then choose Edit dataset.

  3. On the data preparation page that opens, choose Add filter at lower left, and then choose a field that you want to filter.

    
								This is an image of the add filter option when editing a dataset.

    The filter is added to the Filters section at left.

  4. Choose the new filter in the pane to configure the filter. Or you can choose the three dots to the right of the new filter and choose Edit.

    Depending on the data type of the field, your options for configuring the filter vary. For more information about the types of filters that you can create and their configurations, see Filter types in Amazon QuickSight.

  5. When finished, choose Apply.

    Note

    The data preview shows you the results of your combined filters only as they apply to the first 1,000 rows. If all of the first 1,000 rows are filtered out, then no rows show in the preview. This effect occurs even when rows after the first 1,000 aren't filtered out.

Adding filters in analyses

Use the following procedure to add filters to analyses.

To add a filter to an analysis
  1. From the QuickSight start page, choose Analyses.

    
								This is an image of the analyses option on the left pane when you first open QuickSight.
  2. On the Analyses page, choose the analysis that you want to work with.

  3. In the analysis, choose Filter at left, choose Add filter, and then choose a field that you want to filter.

    
								This is an image of the add filter option when in an analysis.
  4. Choose the new filter in the pane to configure it. Or you can choose the three dots to the right of the new filter and choose Edit.

  5. In the Edit filter pane that opens, for Applied to, choose one of the following options.

    • Only this visual – The filter applies to the selected item only.

    • Some visuals – The filter applies to visuals with valid column mappings.

    • All visuals of this dataset – The filter applies to all the items based on this dataset.

    • All applicable visuals – The filter applies to any visuals that have valid column mappings.

    
								This is an image of the applied to option in the edit filter pane.

    Depending on the data type of the field, your remaining options for configuring the filter vary. For more information about the types of filters you can create and their configurations, see Filter types in Amazon QuickSight.