What is Cross Filtering in Looker?

Tired of static dashboards that only raise more questions? Cross-filtering in Looker transforms your reports from passive displays into interactive tools for discovery. This article breaks down exactly what cross-filtering is, how to set it up, and how you can use it to find answers in your data faster.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Cross-Filtering, Really? A Simple Explanation

Imagine your Looker dashboard has two charts: a pie chart showing website traffic by country and a line chart showing daily page views. With a standard dashboard, these are just two separate visuals sitting next to each other.

Now, turn on cross-filtering. You click on the "United States" slice in the pie chart. Instantly, the line chart next to it updates to show you the daily page views for only traffic from the United States. You click on "Canada," and the line chart fluidly updates to show Canadian traffic trends.

That, in a nutshell, is cross-filtering. It’s an interactive feature that allows you to click on a data point in one dashboard tile (a chart or graph) and use that selection as a filter for other tiles on the same dashboard. Instead of manually selecting a filter from a dropdown menu at the top of the page, the charts themselves become the filter controls. This creates a much more intuitive and dynamic way to explore your data and uncover trends that might otherwise stay hidden.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How Cross-Filtering Differs from Standard Dashboard Filters

You might be thinking, "Don't regular filters already do this?" Yes and no. While both achieve the goal of segmenting your data, they function very differently and are suited for different analytic scenarios.

Here’s a breakdown of the key differences:

The best part is that you don't have to choose between them. A well-designed Looker dashboard uses both. You might set a standard filter for "This Quarter," and then use cross-filtering to investigate the performance of individual marketing campaigns or sales reps within that timeframe. They work together to give you both a big-picture view and the ability to instantly dive into the details.

How to Enable Cross-Filtering in a Looker Dashboard: A Step-by-Step Guide

Setting up cross-filtering is surprisingly straightforward once you know where to look. It’s done on a tile-by-tile basis, giving you precise control over your dashboard's interactivity.

Here’s how to do it:

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Enter Edit Mode

First, you need to be able to make changes to your dashboard. From your dashboard view, click the three-dot menu icon dropdown and select "Edit dashboard." This will put you into editor mode, where you'll see options to add, move, or configure tiles.

Step 2: Select the "Parent" Tile

Next, decide which chart you want to use as your filter controller. For example, if you want users to be able to click on a marketing campaign to filter other charts, you would select your "Campaign Performance" tile. Hover over this tile and click the three-dot icon, then choose "Edit."

This will open the configuration window for that specific tile.

Step 3: Navigate to the Cross-Filtering Settings

In the tile’s configuration window, you’ll see several tabs at the top (Query, Settings, Notes). Click on the "Settings" tab. Here, you'll find the "Cross-filtering" section. It's a simple toggle switch - turn it on.

Once you enable it, two critical options will appear.

Step 4: Configure the Cross-Filter

This is where you define exactly how the cross-filter will behave:

• Select field to cross-filter by: This dropdown list contains all the fields available in your selected tile's data source. You need to choose which dimension will act as the filter value when someone clicks the chart. For our marketing campaign example, you would select the "Campaign Name" field. If it were a map in a sales dashboard, you might choose the "Country" or "State" field.
• Select dashboard tiles to update: By default, enabling a cross-filter on one tile applies it to all other tiles on the dashboard. But you don't always want this. For example, you might want clicking on a region to update your sales charts, but not your overall website traffic KPIs. This setting lets you uncheck any tiles you want to remain unaffected. You have full control over which other charts (the "child" tiles) will react to your cross-filter.

Step 5: Save and Test

Once you’ve configured the settings, click "Update" on the tile window, then "Save" on the dashboard itself to exit edit mode.

Now, test it out! Go to the "parent" tile you just configured and click on a data point. Watch as the "child" tiles you selected instantly update. You've successfully added a layer of powerful interactivity to your dashboard.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for Using Cross-Filtering Effectively

While enabling cross-filtering is easy, using it effectively requires a bit of thought about the user experience. Simply turning it on for every tile can create a confusing and counterintuitive mess. Here are a few tips to build dashboards that are both powerful and easy to use.

• Be Purposeful, Not Overwhelming: Not every chart needs to be a cross-filter controller. The best candidates for "parent" filters are summary charts showing dimensions you frequently use to segment data, like categories, channels, regions, or timeframes. A complex, detailed table is usually a poor choice for a filter source.
• Guide Your Users: Cross-filtering isn't always obvious to people who aren’t used to Looker. Consider adding a small text tile to your dashboard with a quick instruction like, "Tip: Click on any chart title to deep-dive into the data." This can dramatically improve the usability of your dashboard.
• Mind the Performance: On dashboards with dozens of tiles or queries pulling from massive datasets, enabling too many cross-filters can sometimes impact loading speed, since each click triggers multiple queries to run again. Be mindful of this and test your dashboard's responsiveness as you add more interactive elements.
• Combine and Conquer: Cross-filters are the perfect complement to traditional dashboard filters, not a replacement. Use the main filters at the top to set the report's overall context (e.g., date range, company division), then use cross-filtering for more specific, ad-hoc investigations within that context.

Final Thoughts

Cross-filtering is a powerful Looker feature that bridges the gap between static reporting and true data exploration. By turning your charts into interactive filter controls, you empower everyone on your team to ask and answer deeper questions on their own, moving faster from data to insight.

Ultimately, the goal is to make sense of your business data an effortless and immediate process. At Graphed, we take this a step further by removing the setup entirely. Instead of configuring settings and learning a new interface, we let you connect all your data sources and create live dashboards simply by describing what you want in plain English. You can even follow up by 'chatting' with your data, getting instant answers to your questions without ever clicking a filter button.