Adding filters - Amazon QuickSight
Adding filters to datasetsAdding filters in analyses

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. Open the QuickSight console.

  2. From the QuickSight start page, choose Datasets.

  3. Choose the dataset that you want, and then choose Edit dataset.

  4. 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 pane.

  5. 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.

  6. 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. Open the QuickSight console.

  2. From the QuickSight start page, choose Analyses.

  3. On the Analyses page, choose the analysis that you want to work with.

  4. In the analysis, choose the Filter icon shown below to open the Filters pane, and then choose ADD.

    The Filter icon that opens the Filters pane.

  5. 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.

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

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

    • Single sheet – The filter applies to a single sheet.

    • Cross sheet – The filter applies to multiple sheets in the dataset.

    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.