How to Add a Filter in Looker Studio

Building a great dashboard in Looker Studio (formerly Google Data Studio) isn't just about crafting beautiful charts, it's about telling a clear story with your data. Filters are your tools for focusing that story, allowing you or your team to slice, dice, and interact with the information to uncover specific insights. This guide will walk you through exactly how to add, configure, and manage filters in Looker Studio, from simple interactive dropdowns to more complex, behind-the-scenes rules.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Understanding Looker Studio Filters

In Looker Studio, filters help you refine the data shown in your report. Instead of presenting all your data at once, you can narrow the view to focus on what matters most. For instance, you could filter a sales report to show only results from a specific region, a marketing dashboard for a single campaign, or website analytics for just mobile traffic. Think of them as a magnifying glass for your data.

There are two primary ways filters work in Looker Studio:

• Filter Controls: These are the interactive elements you add to your report canvas, like dropdown menus, date pickers, or sliders. Report viewers can use these controls to change the data they see in real-time without needing edit access. This is perfect for empowering your team or clients to explore the data for themselves.
• Filter Properties: These are "backend" filters that you, the report editor, apply directly to charts, groups of charts, pages, or the entire report. These rules are fixed and hidden from the viewer. They are used to create permanently focused views, such as a chart that only ever shows data from paid advertising channels or a report that entirely excludes internal employee traffic.

Mastering both types will give you complete control over your reporting, turning a static data dump into a dynamic and useful tool.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Adding Interactive Filter Controls to Your Report

Interactive controls are what make your Looker Studio reports feel like dynamic applications rather than static images. They allow anyone viewing the report to ask their own questions of the data. The most common use case is adding a date range control, but the possibilities are much broader.

Here’s how to add a control to your dashboard:

Step 1: Open Your Report in Edit Mode

You can only add or modify components when you're in "Edit" mode. You'll see the editing panels appear on the right side of your screen.

Step 2: Find the "Add a Control" Menu

In the top toolbar, look for the "Add a control" option. Clicking it will reveal a dropdown list of available control types.

Step 3: Choose and Place Your Control Type

Looker Studio offers several types of controls, each suited for different kinds of data. When you click one, you can then click anywhere on your report canvas to place it, just like adding a chart.

Common Filter Control Types

• Drop-down list: This is the most common choice. It’s perfect for letting users select one or more values from a dimension with a limited number of options, like Device Category (Desktop, Mobile, Tablet) or Country.
• Fixed-size list: Functionally the same as a drop-down list, but all the options are visible at once in a scrollable box. This works well if you have more space on your canvas.
• Input box: Works as a search bar. Users can type in text to filter a dimension. It's ideal for dimensions with thousands of possible values, like Page Title or Campaign Name.
• Slider: This is for numeric fields, either metrics or dimensions. You can use it to let users filter by a range, like Sessions per User (from 1 to 10) or Total Revenue.
• Checkbox: Intended for boolean (true/false) dimensions, but can also work for text dimensions if you only need a single selectable value.
• Date range control: Arguably the most essential control. It allows users to pick a specific time frame for their analysis.

Step 4: Configure the Control's Properties

After you place a control on your canvas, the properties panel will appear on the right. This is where you connect it to your data.

• Control field (under the Setup tab): This is the most important setting. This is the dimension or metric from your data source that the control will filter. For example, if you want users to be able to filter by channel, you would select your data source's "Default Channel Grouping" dimension as the Control field.
• Default selection (under the Style tab): You can pre-select certain values when the report loads. For example, you could have a campaign report default to showing data for "Q4 Holiday Sale." If you leave this blank, it will show data for all values by default.

Example: Creating a Campaign Filter

Let's say you're looking at Google Analytics 4 data and want to filter the report by specific marketing campaigns.

1. Choose Add a control > Drop-down list.
2. Place it at the top of your report.
3. In the Setup panel on the right, make sure your GA4 data source is selected.
4. For the Control field, click on the existing dimension and search for and select "Session campaign."
5. That's it! Now, when you swap to "View" mode, you can click on the dropdown and select one or more campaigns to filter all the charts on the page.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Applying Permanent "Behind-the-Scenes" Filters

Sometimes you don't want the viewer to change the filter. You want a chart or a page to be permanently focused on a specific segment of data. This is where you apply a filter directly to the component itself.

These filters can be applied at four different levels: chart, group, page, or report.

Applying a Chart-Level Filter

This is the most granular level. You create a rule that applies only to a single, selected chart.

1. Click on the chart or table you want to filter.
2. In the Setup panel on the right, scroll down until you see the "Filter" section.
3. Click +Add a filter.
4. A filter creation window will pop up. Here's where you build your rule:
5. Click Save. The filter is now applied to your chart.

Example: You could create an "Include" filter where the "Device Category" "Equals" "Mobile" to create a chart that shows only data from mobile devices.

Managing Filters Across Your Report

Applying filters one chart at a time can be tedious. Looker Studio lets you apply them more broadly to save time and ensure consistency.

Applying Page-Level Filters

If you have an entire page dedicated to a specific theme, like "Paid Search Report" or "Social Media Performance," a page-level filter is ideal. It applies your filter condition to every single chart on that page.

1. Make sure no charts are selected by clicking on the blank canvas.
2. Go to the main menu and select Page > Current page settings.
3. In the properties panel that appears, you’ll see the same "Filter" section. Click +Add a filter.
4. Create your filter just as you would for a single chart. This filter will now cascade down to all components on the current page.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Applying Report-Level Filters

This is the broadest scope. A report-level filter applies to every chart on every page of your entire report. This is most commonly used for universal exclusions.

A classic example is excluding your company's internal traffic to get a cleaner view of customer behavior. You could create an Exclude filter for your office IP addresses and apply it at the report level, so you never have to think about it again.

1. Go to the main menu and select File > Report settings.
2. In the panel that opens, you can add a filter that will govern the entire dashboard.

Best Practices for Using Looker Studio Filters

Once you get the hang of adding filters, it's easy to go overboard. Keep these best practices in mind to create reports that are powerful but also fast and easy to understand.

• Name Your Filters Descriptively: When you create a backend filter, give it a name like "Include - Paid Channels Only" or "Exclude - Test User Emails." When you come back to edit the report months later, you'll thank yourself.
• Position Controls Logically: Place interactive filter controls (like date range and campaign dropdowns) at the top of your report. This is where users intuitively expect to find them.
• Mind Your Report's Performance: Every filter, especially one applied to a high-cardinality dimension or using complex regular expressions (regex), adds processing load. If your report feels slow, review your filters to see if they can be simplified.
• Use Grouping for Efficiency: If you want to apply the same filter to three out of five charts on a page, don't do it manually. Simply hold Shift or Ctrl/Cmd, click the three charts, right-click, and select "Group." Now you can apply a single filter to the entire group.
• Combine Include and Exclude: Sometimes it's easier to Exclude what you don't want than to Include what you do. For instance, if you want to remove two known spam domains from a referrals report, it's much faster to create two Exclude conditions than to Include hundreds of legitimate domains.

Final Thoughts

Filters are what elevate a Looker Studio report from a simple "data art" project into a powerful, interactive analysis tool. By combining interactive controls for exploration with fixed filters for focus, you can tell a targeted and meaningful data story that empowers your entire team to make smarter decisions.

We know that even with great tools, connecting all your data and building these reports from scratch can be a huge time commitment. That's why we created Graphed. Instead of spending hours in an editor, we let you connect data sources like Google Analytics, Shopify, and Facebook Ads in seconds and then simply ask for what you want in plain English. You can say "build a dashboard showing my top ad campaigns by ROI" and get a live, interactive report instantly, with all the necessary filters already in place.