Filter a blended chart directly

Filter properties applied directly to charts based on blended data sources act on the blended data, as opposed to the underlying (pre-blended) data.

Apply an already existing filter

You can apply an existing filter to a chart based on a blended data source as long as that filter uses the same blended data source as the chart. You can't apply a filter based on an unblended data source to a blended chart.

Filter individual data sources in the blend

You can restrict the data from a specific data source used in a chart by editing the blended data source and applying a filter in the Blend Data panel. This filters the data before it is joined with the other data sources in the blend.

To filter a data source in a blend

Apply an already existing filter

You can apply an existing filter to a data source in the blend as long as that filter was created using the same data source. You can't apply a filter based on a different data source.

Filter controls and inherited filters

Inherited filters and charts based on blended data sources must share have compatible schemas (field structure), otherwise the filter won't be applied. If a filter is compatible with pre-blended data, then filter controls, as well as inherited report, page, or group level dimension filters act on the data before it has been blended. Otherwise, the filter acts on the data after it has been blended. Inherited metric filters act on the pre-blended data, if possible.

Under the hood: inherited filters and blended data

When a chart based on a blended data source in your report is subject to an inherited filter, Data Studio processes the data in 5 steps:

(Pre-blend)

Step 1: The data is grouped and aggregated based on the dimensions specified in the Blend Data panel.

Step 2: Inherited dimension filters and compatible metric filters are applied to the data sources included in the Blend Data panel.

(Blend)

Step 3: The data is blended using the specified join keys.

(Post-blend)

Step 4: The data is grouped and aggregated based on the dimensions in the chart.

Step 5: Metric filters, if compatible with blended data, are applied to the chart.

Data controls and blended data

Data controls let viewers select the data set used by the report. When your report includes a data control, it acts on the report's unblended data sources.

Manage filters on blended data

Just like regular filters, you can access filters on blended data sources via the Resources > Manage filters menu.