Create, edit, and manage filters

Add a filter to a chart or control

1. Edit your report.
2. Select the chart or control you want to filter. You can also filter a group of charts and/or controls.
3. Select the Setup tab in the properties panel.
4. Click +Add a filter.
5. Click CREATE NEW FILTER.
   You can also reuse an existing filter
6. Name the filter.
7. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression.
8. Select the dimension or metric by which to filter.
9. Select the comparison operator (e.g. Equals, Contains, Greater than, etc.).
10. Provide a comparison value for the expression.
11. (Optional) To add an OR clause, click OR on the right of the condition.
12. (Optional) To add an AND clause, click AND below the clause.
13. Click SAVE.

Add a filter to the entire report or to a page

For the entire report, in the menus, select File > Report settings.

For a page, in the menus, select Page > Current page settings.

Then:

1. On the right, in the properties panel, click +Add a filter.
2. Setup the filter using the previous instructions.

Edit a filter

1. Edit your report.
2. Select the chart or control that has the filter. Or use the page settings or report theme menus, as described above.
3. Select the Setup tab in the properties panel.
4. Click edit .

You can also create, edit, and duplicate filters using the filter manager.

Reuse an existing filter

Once you've added a filter to a report, you can use it in other components or even other reports. Adding an existing filter to a component reuses that filter. Reusing a filter does not create a copy of the filter. It's actually the same filter, so if you later edit it in one place, that changes the filter everywhere in the report.

If you reuse a filter for a chart or control with an incompatible data source, the chart or control will display an error. You can fix this by editing the filter to use dimensions or metrics that are common to both data sources.

Learn more about filters and data sources.

Copy components and reports with filters

When you make a copy of a page or component within a report, its filters are reused by the copy.

If you copy a filtered component into a different report, Looker Studio makes a new copy of the filter. It has no relationship to the original filter. Note that if you copy and paste the component a second time, you will get another copy of the filter. The 2 copies are not related.

If you make a copy of a report and change the data source, any filters in the report get the new data source.

Manage filters

The filter manager lists of all the filters in a report. Use this list to duplicate, edit, or remove filters. You can also create a new filter using the filter manager.

When you edit or create a filter from the filter manager, you can select which data source is used by the filter. If you change the data source for an existing filter and the new schema doesn't match the original data source, the filter may break.

Display the filter manager

1. Edit your report.
2. In the menus, select Resource > Manage filters.
3. Use the links in the Actions column to manage the filters in your report.

Edit a filter

To edit the filter configuration, click Edit in the Actions column.This is the same as using the edit pencil as described above.

Duplicate a filter

To create a copy of the filter, click Duplicate in the Actions column. You can then modify the filter conditions and apply it to other charts in the report.

Remove a filter

To delete the filter permanently from the report, click Remove in the Actions column.

Be careful! You can't undo this action.