Cross-filtering makes it easier and more intuitive for viewers of [dashboards](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards) to interact with a dashboard's data and understand how one metric affects another. With cross-filtering, users can select a data point in one dashboard tile to have all dashboard tiles automatically filter on that value.
Your browser does not support the embedded video.

Multiple cross-filters can be created at one time, and cross-filters can be used in conjunction with [standard dashboard filters](https://docs.cloud.google.com/looker/docs/2622/filters-user-defined-dashboards.md.txt#understanding_dashboard_filters).


## Enabling cross-filtering on dashboards

> For cross-filtering to be turned on successfully, all dashboard tiles must be created from the same [Explore](https://docs.cloud.google.com/looker/docs/2622/creating-and-editing-explores.md.txt#explores_are_the_starting_point_for_exploration).

1. Make sure you have the [**Manage Access, Edit**](https://docs.cloud.google.com/looker/docs/2622/organizing-spaces#folder_access_levels) access level for the dashboard.
2. Enter the dashboard's [edit mode](https://docs.cloud.google.com/looker/docs/2622/editing-user-defined-dashboards.md.txt#entering_edit_mode_in_dashboards) by selecting **Edit dashboard** from the three-dot dashboard menu.
3. Select **Filters** in the blue toolbar at the top of the dashboard, and enable the **Cross-filtering** switch.
4. If the dashboard contains any [unsupported visualization types](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#unsupported_visualizations), a pop-up window indicates that the dashboard contains tiles that cannot initiate cross-filtering. Select **OK** to continue.
5. Select **Save** in the dashboard toolbar.

   > LookML developers may be able to use [aggregate awareness](https://docs.cloud.google.com/looker/docs/2622/aggregate_awareness.md.txt) to optimize cross-filtering performance. To learn more about using aggregate awareness with dashboards, visit the [Creating user-defined dashboards](https://docs.cloud.google.com/looker/docs/2622/creating-user-defined-dashboards.md.txt#improving_dashboard_performance_using_aggregate_awareness) documentation page.


## Creating cross-filters on dashboards

Once cross-filtering is enabled on an instance and a dashboard, you can create cross-filters.

1. Select a data point within a tile containing a [supported visualization](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#supported_visualizations).
   For bar, column, line, area, scatterplot, and pie charts, you can also select the chart legend.

   ![](https://docs.cloud.google.com/static/looker/docs/images/xf-initial-click-720.png)
2. The tile creating the cross-filter highlights that data point and shows all other data points as unavailable by displaying them in grey. (For table visualizations, the tile displays a bold highlight on the selected value instead of displaying the other data points as unavailable.) All other data tiles will be filtered by the value of that data point. The cross-filter field and value appear at the top of the dashboard for reference.

   ![](https://docs.cloud.google.com/static/looker/docs/images/xf-initial-result-720.png)
3. To add an additional value to an existing cross-filter, hold down the Command (Mac) or Control (Windows) key on your keyboard while selecting additional data points or legends.

4. The tiles filter on the additional value as well. The additional value for the cross-filter appears at the top of the dashboard.

   ![](https://docs.cloud.google.com/static/looker/docs/images/xf-additional-result-720.png)
5. To add a new cross-filter, select another data point on any tile containing a supported visualization type. All tiles filter by that cross-filter as well, and an additional field and value appears at the top of the dashboard.

   ![](https://docs.cloud.google.com/static/looker/docs/images/xf-multiple-filters-720b.png)

### Supported and unsupported visualization types

Each data tile on a dashboard contains a visualization, and the type of visualization determines whether or not you can use the data points on that tile to create cross-filters.

#### Supported visualization types

The following visualization types are supported and can create cross-filters:

- [Table charts](https://docs.cloud.google.com/looker/docs/2622/table-options) (Table visualizations display a bold highlight on the selected value instead of showing the other data points as unavailable by displaying them in grey.)
- [Table (legacy) charts](https://docs.cloud.google.com/looker/docs/2622/legacy-table-options.md.txt) (Table (legacy) visualizations display a bold highlight on the selected value instead of showing the other data points as unavailable by displaying them in grey.)
- [Column charts](https://docs.cloud.google.com/looker/docs/2622/column-options.md.txt)
- [Bar charts](https://docs.cloud.google.com/looker/docs/2622/bar-options.md.txt)
- [Line charts](https://docs.cloud.google.com/looker/docs/2622/line-options.md.txt)
- [Area charts](https://docs.cloud.google.com/looker/docs/2622/area-options.md.txt)
- [Scatterplot charts](https://docs.cloud.google.com/looker/docs/2622/scatter-options)
- [Pie charts](https://docs.cloud.google.com/looker/docs/2622/pie-options)
- [Map charts](https://docs.cloud.google.com/looker/docs/2622/map-options.md.txt) that use the [**Points**](https://docs.cloud.google.com/looker/docs/2622/map-options.md.txt#points) option for data of [`type: location`](https://docs.cloud.google.com/looker/docs/2622/reference/param-dimension-filter-parameter-types#location) and map charts that use data of [`type: zipcode`](https://docs.cloud.google.com/looker/docs/2622/reference/param-dimension-filter-parameter-types#zipcode)
- [Static map (regions) charts](https://docs.cloud.google.com/looker/docs/2622/map-regions-options.md.txt)
- [Static map (points) charts](https://docs.cloud.google.com/looker/docs/2622/map-points-options.md.txt)
- [Word cloud charts](https://docs.cloud.google.com/looker/docs/2622/word-cloud-options)
- [Donut multiples charts](https://docs.cloud.google.com/looker/docs/2622/donut-multiples-options.md.txt)
- [Funnel charts](https://docs.cloud.google.com/looker/docs/2622/funnel-options.md.txt)
- [Timeline charts](https://docs.cloud.google.com/looker/docs/2622/timeline-options)
- [Waterfall charts](https://docs.cloud.google.com/looker/docs/2622/waterfall-options)
- [Boxplot charts](https://docs.cloud.google.com/looker/docs/2622/boxplot-options.md.txt)
- [Custom visualizations](https://docs.cloud.google.com/looker/docs/2622/admin-panel-platform-visualizations.md.txt)

For information on how to enable cross-filtering on custom visualizations, visit the [API 2.0 Reference documentation](https://github.com/looker-open-source/custom_visualizations_v2/blob/master/docs/api_reference.md#rendering-data) in the [`custom_visualizations_v2`](https://github.com/looker-open-source/custom_visualizations_v2) GitHub repo.


#### Unsupported visualization types

The following visualization types are not supported and cannot create cross-filters; however, they can be filtered by cross-filters:

- [KPI (Single Value) charts](https://docs.cloud.google.com/looker/docs/2622/kpi-single-value-options.md.txt)
- [Single value (legacy) charts](https://docs.cloud.google.com/looker/docs/2622/single-value-options)
- [Single record charts](https://docs.cloud.google.com/looker/docs/2622/single-record-options)
- [Map charts](https://docs.cloud.google.com/looker/docs/2622/map-options.md.txt) that use [**Plot** options](https://docs.cloud.google.com/looker/docs/2622/map-options.md.txt#plot_menu_options) other than **Points** for data of [`type: location`](https://docs.cloud.google.com/looker/docs/2622/reference/param-dimension-filter-parameter-types#location), or map charts that use [map layers](https://docs.cloud.google.com/looker/docs/2622/reference/param-model-map-layer)
- Visualizations that use [grid layout](https://docs.cloud.google.com/looker/docs/2622/editing-user-defined-dashboards.md.txt#tile_size_and_grid_layout)
- Visualizations based on [merged results](https://docs.cloud.google.com/looker/docs/2622/merged-results.md.txt) when all queries in the merged results are from the same Explore as the rest of the dashboard tiles (if a dashboard contains a merged results tile with queries from different Explores, cross-filters cannot be enabled for that dashboard)

Regardless of visualization type, you cannot create cross-filters (or standard [dashboard filters](https://docs.cloud.google.com/looker/docs/2622/filters-user-defined-dashboards.md.txt#understanding_dashboard_filters)) on a [custom field](https://docs.cloud.google.com/looker/docs/2622/custom-fields.md.txt).

### Using range selection

You can use range selection to cross-filter a dashboard on an entire range. To use range selection:

- A dashboard tile must use a line, area, or scatterplot visualization.
- The visualization must use continuous data in the x-axis, which is usually numeric data, data using [timeframes](https://docs.cloud.google.com/looker/docs/2622/reference/param-field-dimension-group#timeframe_options), or data of a [time-based type](https://docs.cloud.google.com/looker/docs/2622/reference/param-dimension-filter-parameter-types#individual_time_and_date_types), although some timeframes and time types are [not continuous](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#non-continuous_time_types).
- The visualization's x-axis [**Scale Type**](https://docs.cloud.google.com/looker/docs/2622/line-options.md.txt#scale_type) must not be **Ordinal** . If it is **Ordinal**, range selection creates separate cross-filters for each data point selected.

To use range selection, left select one end of the range, and hold and drag to the other end of the range. When you release your hold, the cross-filter will appear at the top of the dashboard and the other tiles will filter on that range. You cannot add [additional values](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#additional_value) to range selection cross-filters.

For example, the dashboard viewer in the following image selected the weeks of November 25th and December 2nd. The range selected is shaded and the cross-filter appears at the top of the dashboard.

![An example of cross-filtering a dashboard.](https://docs.cloud.google.com/static/looker/docs/images/xf-range-selection-2104.png)

Each data point encompasses a week. While the shaded area appears to end on December 2nd, the cross-filter actually ends on December 9th, the last day of that week. The cross-filter at the top of the dashboard displays the full range, November 25th through December 9th.

#### Non-continuous time types

The [timeframes](https://docs.cloud.google.com/looker/docs/2622/reference/param-field-dimension-group#timeframe_options) and [time-based types](https://docs.cloud.google.com/looker/docs/2622/reference/param-dimension-filter-parameter-types#available_time-based_types) in the following list are not considered continuous. If you use range selection with them, a separate cross-filter is created for each data point that you select.

- `date_time_of_day`
- `date_day_of_week`
- `date_month_name`
- `date_quarter_of_year`
- `date_fiscal_quarter_of_year`


### Using cross-filters with standard dashboard filters

A dashboard can contain both cross-filters and standard [dashboard filters](https://docs.cloud.google.com/looker/docs/2622/filters-user-defined-dashboards.md.txt#understanding_dashboard_filters). Cross-filters appear after standard filters at the top of the dashboard and are a darker blue. For example, in the following image, the filter on Status is a standard filter. The filters on Created Month and Traffic Source are cross-filters:

![Sample line chart showing the visual style of cross-filters.](https://docs.cloud.google.com/static/looker/docs/images/cross-filters-vs-standard-filters-720.png)

Cross-filters differ from standard dashboard filters in a few ways:

- Cross-filtering must be [enabled separately](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#enabling_cross-filtering_on_dashboards_(beta)) for your Looker (Google Cloud core) instance and dashboard(s).
- You do not need [edit](https://docs.cloud.google.com/looker/docs/2622/organizing-spaces#folder_access_levels) access to a dashboard to create or change cross-filters (you do need edit access to [turn on](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#enabling_cross-filtering_for_individual_dashboards_(beta)) cross-filtering for a dashboard).
- Cross-filters cannot be configured with the same [dashboard controls](https://docs.cloud.google.com/looker/docs/2622/filters-user-defined-dashboards.md.txt#dashboard_(beta)_filter_controls) as standard filters.
- Specific cross-filters are not visible to other users unless the cross-filtered dashboard is [shared](https://docs.cloud.google.com/looker/docs/2622/cross-filtering-dashboards.md.txt#sharing_cross-filtered_dashboards) through a link or embedded into a website.
- Cross-filters are not saved to the dashboard. Once you navigate away from a dashboard, cross-filters are cleared.
- Cross-filters are not applied to dashboard [downloads](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards#downloading_data_from_a_dashboard_(beta)), schedules, or [alerts](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards#dashboard_(beta)_tiles).

While using cross-filters, you can make [temporary changes to a dashboard's filter values](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards#temporarily_changing_filter_values_on_dashboards). However, if you create a cross-filter on the same field that a standard filter is using, the standard filter value cannot be changed until the cross-filter is removed.

Cross-filters can also be used on dashboards that contain [filters on visualization tiles](https://docs.cloud.google.com/looker/docs/2622/filters-user-defined-dashboards.md.txt#filters-on-visualization-tiles). If a cross-filter is applied to the same field as a visualization filter or a dashboard filter, the cross-filter takes precedence and overrides the visualization and dashboard filter values for that tile. For more information about filter precedence, see [Dashboard filter override behavior](https://docs.cloud.google.com/looker/docs/2622/filters-user-defined-dashboards.md.txt#dashboard_filter_override_behavior). Any cross-filters that are applied to the dashboard are not displayed in a tile's [**Show filters** window](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards#show-filters).

If you have [edit](https://docs.cloud.google.com/looker/docs/2622/organizing-spaces#folder_access_levels) permissions for a dashboard, you can edit and create standard dashboard filters while cross-filters are enabled. However, entering [edit mode](https://docs.cloud.google.com/looker/docs/2622/editing-user-defined-dashboards.md.txt#entering_edit_mode_in_dashboards) to edit or add standard filters will clear any current cross-filters.

## Sharing cross-filtered dashboards

Cross-filters are not saved to a dashboard. You can share them in the following ways:

- By [sharing a link to the dashboard](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards#getting_a_dashboards_link)
- By [embedding](https://docs.cloud.google.com/looker/docs/2622/embedding-dashboards) a dashboard that contains cross-filters

## Drilling when cross-filtering is enabled

When cross-filtering is enabled on a dashboard, you can right-click to [drill](https://docs.cloud.google.com/looker/docs/2622/viewing-and-interacting-with-explores#drilling_down_into_the_data) into the visualization's data.

## Removing cross-filters

There are two options to remove an individual cross-filter:

1. Select the data point being cross-filtered again.
2. Select the **X** next to the cross-filter value at the top of the dashboard.

![](https://docs.cloud.google.com/static/looker/docs/images/delete-individual-cross-filters-720.png)

If there are multiple cross-filters, you can clear them all by selecting the **X** to the right of the filter values at the top of the dashboard.

Entering [edit mode](https://docs.cloud.google.com/looker/docs/2622/editing-user-defined-dashboards.md.txt#entering_edit_mode_in_dashboards) also clears all cross-filters.

## Optimizing cross-filtering performance using aggregate awareness

LookML developers may be able to optimize query performance of cross-filtered dashboards by using [aggregate awareness](https://docs.cloud.google.com/looker/docs/2622/aggregate_awareness.md.txt). With aggregate awareness, developers can create [aggregate tables](https://docs.cloud.google.com/looker/docs/2622/aggregate_awareness.md.txt) under LookML `explore` parameters, which can optimize queries for one or more tiles in a dashboard. The first step is to [get the aggregate table LookML](https://docs.cloud.google.com/looker/docs/2622/viewing-dashboards#getting_aggregate_table_lookml_from_a_dashboard_(beta)), which appears under the **Get LookML** option in the dashboard three-dot menu. For more information, see the [`aggregate_table`](https://docs.cloud.google.com/looker/docs/2622/reference/param-explore-aggregate-table#getting_aggregate_table_lookml_from_a_dashboard) parameter documentation page.