Adding Filters to Reports

You can add filters to a report at the report, report page, and visual level.

The report must be open in Editing view and the Filters, Visualizations, and Field panes must be open.
Note: Fields that are marked as measures cannot be added to filters.
  1. To add filters to all pages in the report, do the following:
    1. In the Fields pane, select the field to use as a report-level filter.
    2. Drag it to the Filters pane and drop it in the Filters on all pages section.
    3. Use the Advanced filtering or Basic filtering options to further refine the report filtering. For example, if filtering by DayOfWeekName, you can refine results to include only thing that happened on Monday.
      A report showing the DayOfWeekName field circled in red and marked with a letter A, the Filters on all pages heading circled in red marked with a letter B, and the Monday option selected and circled in red marked with letter C.
    All visuals across all pages of the report use the new filter.
  2. To add filters to the report page, do the following:
    1. In the Fields pane, select the field to use as a page-level filter.
    2. Drag it to the Filters pane and drop it in the Filters on this page section.
    3. Use the Advanced filtering or Basic filtering options to further refine the report page filtering.
      A report page showing the DayType field circled in red and marked with a letter A, the Filters on this page heading circled in red marked with a letter B, and the Advanced filtering option circled in red and marked with a letter c.
    All visuals on the page use the new filter.
  3. To add filters to a specific visual, do the following:
    1. Select a visual.
      The Filters pane shows filters applied to the visual in the Filters on this visual section.
      A visual and applied filters circled in red.
    2. Select the field that to add as a visual-level filter from the Fields pane and drag the field to the Add data fields here in the Filters on this visual section.
    The filter is applied to the visual.

    Consumers are able to interact with available filters on the report, report page, and visual level.


    Reading view for a report with visual, page, and report filters circled in red.
  4. To prevent consumers from selecting their own values in filters, in the Filters pane, select the eye symbol.
    The eye symbol has a slash through it to indicate filters are hidden.
    The Filters pane showing the eye symbol circled in red.