Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

Add a quick filter

Quick filters provide a flexible, ad hoc way to explore your data. Use quick filters to easily change how the data in the report is filtered without changing the report configuration for other users.

In this article:

The filter bar

Add quick filters to your report by using the filter bar. When you are in edit mode, the filter bar appears beneath the toolbar at the top of your screen. The filter bar shows all the quick filters, as well as any controls and chart cross-filters that you've applied.

The Looker Studio editor interface, with the Add quick filter and Filter bar buttons called out.

Legend:

  1. Add quick filter button.
  2. Filter bar toggle.

To toggle the filter bar on and off:

On the right, in the panel manager, click Filter bar .

Tip: If you don't see the panel manager, properties panel, or data panel, at the bottom right corner of the screen, click Keyboard arrow left.Show panels.

Add a quick filter to your report

To add a quick filter to your report, in the filter bar, click +Add quick filter, and then select a dimension from the field list. If your report contains multiple data sources, you may need to expand the fields for that data source first.

Alternatively, you can drag a dimension from the data panel to the filter bar.

Quick filters appear as a "chip" in the filter bar, with a filter icon Control icon. preceding the name of the field you selected. To configure the quick filter, click the chip, then:

  • For numeric dimensions, use the slider control to refine the range of values.
  • For date dimensions, select a date range using the date picker.
  • For text, geo, and other dimension types, select a value or values from the list.

Edit a quick filter

To modify a quick filter, click its chip in the filter bar, then select a new value to filter by.

Note: In addition to quick filters, the filter bar also shows all of the filter controls and chart cross-filters currently affecting the data in the report. These appear with a bar chart icon .

Note: You can't edit a filter control or change a chart cross-filter by using the filter bar.

Remove a filter

Removing a filter control or chart cross-filter from the filter bar resets that individual control or cross-filter.

To remove an individual quick filter, click the X in the quick filter's chip.

Clear the filter bar

Clearing the filter bar deletes all quick filters and resets any filter controls or chart cross-filters.

To clear the filter bar, click More options.More options, then select Remove. Clear filters.

Reset the filter bar

Resetting the filter bar removes any values from existing quick filters, but leaves the filter chip in the filter bar. Resetting the filter bar also resets any filter controls or chart cross-filters on the report.

To reset the filter bar, in the filter bar, click Reset.

Note: the report-level Reset button will also reset the filter bar, filter controls, and chart cross-filters, but will also reset other report refinements, such as sorting, optional metrics, drill down, and so on.

The Looker Studio editor interface, with the report-level reset button and filter bar reset button called out.

Legend:

  1. Report-level reset button.
  2. Filter bar reset button.

Limits of quick filters and the filter bar

  • Quick filters are only applied in edit mode and do not persist when you view the report. However, when you switch back to edit mode, any quick filters you've applied are preserved.
  • You can only create quick filters on dimensions. Creating quick filters based on metrics is not supported.
  • The filter bar doesn't show the effects of filter properties, date range controls, or data controls on the report.
  • Quick filters apply to the entire page. You can't apply a quick filter to a single component or group of components.

Was this helpful?

How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
6975804752522371165
true
Search Help Center
true
true
true
true
true
102097