How to Create an Interactive Dashboard in Looker

A static dashboard is just a picture, but an interactive dashboard is a conversation with your data. Making your Looker (now Looker Studio) dashboards interactive is the key to empowering your team to find their own answers without requesting a new report for every question. This guide walks you through transforming your one-dimensional reports into dynamic, exploratory tools using filters, cross-filtering, and drill-downs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Interactivity Matters in a Dashboard

Before jumping into the “how,” let’s touch on the “why.” An interactive dashboard does more than just present numbers, it invites users to explore them. This shift from passive viewing to active analysis is a game-changer for a few key reasons:

• It empowers self-service analytics. When users can filter by date, region, or campaign, they can answer their own follow-up questions. This frees up data analysts from endlessly pulling slightly different versions of the same report.
• It tells a deeper story. A stakeholder might start with a high-level view of total revenue, then filter down to a specific product line, and then use cross-filtering to see which marketing channels are driving sales for that product. Each interaction reveals another layer of the story.
• It increases adoption. People are far more likely to use a tool that feels responsive and helpful. Interactive elements make a dashboard feel less like a static report and more like a dedicated application for understanding the business.

Core Concepts: Building Blocks of a Looker Dashboard

To make a dashboard interactive, you first need to understand its fundamental components. Getting these basics down will make the rest of the process much clearer.

Looks and Tiles

In Looker, a "Look" is a single, saved data visualization. Think of it as one chart or one table that answers a specific question (e.g., "What were our total sales per month?"). When you place a Look onto a dashboard, it becomes a "Tile." Your dashboard is essentially a collection of these tiles, arranged to tell a comprehensive story.

Explores

An "Explore" is a specially prepared starting point for data analysis. Data developers build Explores using LookML (Looker’s modeling language) to define how database tables join together and which fields are available for analysis. As a dashboard creator, you start in an Explore to build the queries that will eventually become your tiles. You might start in a "Sales" Explore to analyze revenue or a "Marketing" Explore to look at campaign performance.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Dashboard Filters

Filters are the primary controls your viewers will use to interact with the dashboard. They are dropdowns, sliders, or text fields that allow users to change the data displayed across multiple tiles at once. For example, a single "Date Range" filter can update every tile on the dashboard to show data for the last quarter instead of the last year.

Step-by-Step: Adding Standard Dashboard Filters

Adding filters transforms your dashboard from a static gallery into an interactive workspace. Let's walk through how to add a basic filter, like one for a date range.

Step 1: Get into Edit Mode

First, open your dashboard. In the top-right corner, you'll see a menu or button that allows you to enter "Edit Mode." This unlocks the dashboard canvas so you can add, move, and edit tiles and filters.

Step 2: Add a New Filter

While in Edit Mode, look for an "Add" or "Add Filter" button, typically located in the top toolbar. Clicking this will bring up the filter configuration window, allowing you to create the control panel for your dashboard.

Step 3: Configure Your Filter

This is where you define how your filter behaves. You’ll need to set up a few key options:

• Title: Give your filter a descriptive name that users will understand, like "Date Range" or "Filter by Country."
• Control: Choose the type of UI element you want. For dates, a Date Range filter is best. For categories like a country or sales representative, a Dropdown Menu or Buttons might work well.
• Model & Explore: Tell Looker where to find the data field for this filter. You'll select the correct analytical model and then the specific Explore containing your data.
• Field: Pick the exact data field you want to filter on, such as Orders.CreatedAt Date or Users.Country.
• Default Value: This is an optional but highly recommended step. Setting a default value (e.g., "is in the past 90 days") ensures the dashboard loads with relevant data right away.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Connect the Filter to Your Tiles

A common mistake is to create a filter but forget to tell it which tiles to control. For each tile on your dashboard, you need to link your new filter to the relevant field within that tile's data.

In the filter's configuration menu, go to the "Tiles To Update" tab. Here, you'll see a list of every tile on your dashboard. For each tile you want the filter to affect, select the corresponding field. For our "Date Range" filter, you’d link it to the order_date field on your "Total Revenue" tile and the signup_date field on our "New Users" tile.

Step 5: Save and Test

Once you’ve configured everything, click "Save" to exit Edit Mode. Now for the fun part: play with your filter! Select different date ranges or categories and watch as all your connected tiles update in real-time. This confirms everything is wired up correctly.

Level Up Your Interactivity: Beyond Simple Filters

Standard filters are essential, but Looker offers a few more advanced features that can make your dashboard even more intuitive and powerful.

Using Cross-Filtering

Have you ever wanted to click on a bar in one chart and have all the other charts on the page automatically filter to that selection? That’s cross-filtering, and it creates a highly intuitive, fluid experience for your audience.

To enable it, enter Edit Mode and go to the dashboard's Settings. You should find an option for "Cross-filtering." Once enabled, users can click on a data point on almost any tile - like a country on a map, a specific campaign in a pie chart, or a day on a timeline - and that selection will be applied as a filter to the entire dashboard. Users can easily see how one aspect of the data relates to all the others on the page.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Setting Up Drill-Downs

Drilling down is the process of clicking on an aggregate number to see the individual records that make it up. For example, if a tile shows you have 150 new trial signups, a drill-down would let you click that number and see a table with the names, email addresses, and signup times of those 150 specific users.

This functionality is typically defined by data analysts or developers in the underlying LookML code. However, as a dashboard creator, you can ensure this experience works by using fields that have been enabled for drilling. When you click a number in a table or a data point on a chart, if a drill path is available, Looker will show you the "Show all" option to reveal the detailed data.

Best Practices for User-Friendly Dashboards

Building an interactive dashboard is part technology, part design. Here are a few tips to ensure your dashboards aren't just functional, but genuinely user-friendly.

• Keep Filters Obvious: Place your main filters right at the top of the dashboard where everyone can see them. Use clear, simple language so there's no confusion about what each filter does.
• Set Sensible Defaults: Configure your filters to load a default view that is useful for most people (e.g., the last 30 days). This prevents the dashboard from loading with no data or an irrelevant time period.
• Guide Your Audience: Use Text tiles to give your dashboard a main title, sections, and even short descriptions explaining what a chart represents or how to use a filter. Don't assume users will know everything.
• Don't Overdo It: More interactivity isn't always better. A dashboard with 15 different filters can be more confusing than helpful. Focus on the few key filters that answer the most common business questions.

Final Thoughts

Creating an interactive Looker dashboard is about moving beyond static reporting and providing a dynamic canvas for exploration. By mastering filters, cross-filtering, and drill-downs, you can build powerful tools that empower your team to discover insights on their own and make better, data-informed decisions.

While Looker is a powerful tool, you can see that setting up an interactive experience involves many steps, from configuring tiles to linking each one to a filter. We wanted to strip away all that manual setup. With Graphed you simply connect your data sources like Google Analytics, Shopify, or HubSpot and ask for what you need in plain English. You can say, "create a sales dashboard showing revenue over time, top-selling products, and revenue by country," and our AI instantly builds a fully interactive, filterable dashboard, handling all the connections for you in seconds.