What is Cross Report in Power BI?

Jumping between data reports to connect the dots is a common headache. You start with a big-picture business dashboard, spot something interesting, and then have to close it, open another report, and manually apply filters just to find the details you need. This is where Power BI's cross-report drillthrough becomes your new best friend. This feature lets you create a seamless connection between your summary and detailed reports, allowing users to navigate between them with a single click. In this guide, we’ll walk through exactly what a cross-report drillthrough is, how to set it up step-by-step, and explore practical examples to show you how it can transform your reporting workflow.

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 a Cross-Report Drillthrough (and Why Should You Care?)

In simple terms, a cross-report drillthrough is like a smart hyperlink that connects visuals in one Power BI report (the source) to a specific page in a different Power BI report (the target). When a user clicks on a data point in the source report, it takes them to the target report and automatically filters the view based on the data they clicked.

This is different from a standard drillthrough, which only works for pages within the same report. Cross-report breaks down the walls between separate reports, allowing you to create a much more organized and intuitive user experience.

Think of it like browsing a website. You land on a homepage with high-level summaries. You click a link like "Learn more about our products," and you're taken to a detailed product page. Cross-report drillthrough does the same thing for your data, turning a collection of standalone reports into an interconnected web of insights.

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

The Key Benefits

Why bother setting this up? The advantages become clear once you see it in action:

• Keep Dashboards Clean and Focused: Your main dashboards can stay high-level and clutter-free. Instead of cramming every possible chart onto one page, you can provide an overview and let users drill through for the nitty-gritty details only when needed.
• Connect Strategy to Operations: Bridge the gap between a high-level executive dashboard showing company-wide KPIs and a granular operational report used by a specific team. A CEO could look at total revenue by country, and with one click, drill down into a regional manager’s detailed sales pipeline for that country.
• Create a Guided User Journey: You can guide users through a logical analysis path. Start them with the "what" (e.g., a drop in sales) and empower them to instantly find the "why" (e.g., underperformance of a specific product category) without having to hunt for the right report.
• Promote Report Specialization: Different teams need different levels of detail. Your marketing team can have a dedicated report for campaign performance, while the sales team has one for rep-level activity. Cross-report drillthrough lets these specialized reports work together without getting in each other's way.

Setting Up Your Power BI Reports for Drillthrough

Before you can get started, there are a couple of small but mandatory setup steps. The process involves enabling the feature in Power BI Desktop for both the report you're starting from (the source) and the one you’re landing on (the target).

Prerequisites for Success

For cross-report drillthrough to work correctly, two conditions must be met:

1. Both the source and target reports must be published to the same workspace in the Power BI service.
2. The data field you want to use for filtering (e.g., ‘Product Name’ or ‘Campaign ID’) must exist in the data models of both reports. The table name and column name must match exactly. Power BI needs this common field to know how to pass the filter from one report to the other.

How to Enable the Cross-Report Feature

You need to turn this feature on for both the target and source reports. The steps are identical for each.

1. Open your Power BI report in Power BI Desktop.
2. Go to File > Options and settings > Options.
3. In the new window, navigate to the Current File section on the left sidebar and click on Report settings.
4. Scroll down until you see the "Cross-report drillthrough" heading and check the box that says: Allow visuals in this report to use drillthrough targets from other reports.

Click "OK" and save your report. Remember to do this for both your source report and your target report. Now you’re ready to configure the connection.

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

Configuring the Target Report (The Destination)

The target report is where all the magic is configured. This is the detailed report where users will land after clicking. Here, you'll define which page can be accessed from other reports and which data field should act as the filter.

Let's say you have a detailed report page called "Campaign Performance Details" and you want users to be able to drill through to it using the Campaign Name field.

1. In Power BI Desktop, open the target report and navigate to the "Campaign Performance Details" page.
2. With no visuals selected, look at the Visualizations pane on the right side of the screen.
3. Find the Drillthrough section at the bottom. You should see a toggle labeled Cross-report. Switch this toggle to On.
4. An empty box labeled "Add drill-through fields here" will appear. Find the Campaign Name field in your Data pane and drag it into this box.

That's it! As soon as you add a field to the drillthrough well, Power BI automatically does two things:

• It marks this page as a valid "target" for other reports in the same workspace.
• It adds a "Back" button icon to the report page. This button is designed to take the user back to the source report page they came from with a simple Ctrl + Click. You can resize and reformat this button like any other visual.

Once you’ve configured the necessary fields, Publish your report to the desired workspace in the Power BI service.

How to Use the Cross-Report Drillthrough in Action

With both reports configured and published, it’s time to see your work pay off. The user experience is simple and intuitive.

1. Open your source report in the Power BI service.
2. Find a visual that uses the field you designated as the drillthrough filter. For our example, this would be a chart showing metrics by Campaign Name.
3. Right-click on a specific data point you want to investigate - for instance, the bar for the "Summer Sale 2024" campaign.
4. Hover over the Drillthrough option in the context menu. You will now see the name of your target page ("Campaign Performance Details") appear as an option.
5. Click on it.

Instantly, Power BI will take you to the "Campaign Performance Details" report page. Better yet, the entire page will already be filtered to show only the data for the "Summer Sale 2024" campaign. You just seamlessly jumped from a high-level summary to a deep dive analysis without applying a single manual filter.

Practical Use Cases and Examples

The concept is powerful, but how can you apply it to your business? Here are a few relatable scenarios for marketing, sales, and e-commerce teams.

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

1. From Company-Wide Sales Dashboard to a Regional Deep Dive

• Source Report: An executive dashboard showing key sales metrics like total revenue and profit margin. A world map visual displays revenue by country.
• Target Report: A detailed regional performance report with breakdowns of sales by individual reps, deal velocity, closure rates, and top customer accounts.
• How it Works: A sales director sees that Canada is outperforming expectations on the map. They right-click on "Canada," and drill through to the "Canadian Sales Performance" report, which is instantly filtered for Canada. From there, they can immediately identify the top-performing sales reps in that specific region.

2. From a Marketing Overview to a Specific Campaign Analysis

• Source Report: A holistic marketing dashboard summarizing key metrics across all channels - Cost Per Lead, Customer Acquisition Cost, and conversion rates for Google Ads, Facebook Ads, and Email Marketing.
• Target Report: A dedicated Google Ads report with granular data on spend, clicks, conversion rate, and ROAS (Return On Ad Spend) for every single campaign, ad group, and keyword.
• How it Works: A marketing manager notices that cost per lead for "Google Ads" is unusually low in the source report. They right-click on "Google Ads," drill through to the target report, and see a filtered view showing only Google Ads data. They immediately spot a specific new campaign that's driving all the high-quality, low-cost leads.

3. From an E-commerce Store Summary to a SKU-Level Deep Dive

• Source Report: A general Shopify dashboard that a store owner uses to track overall revenue, order volume, and top-selling product categories.
• Target Report: An in-depth inventory and sales velocity report showing sales, stock levels, profit margin, and days of supply for every individual SKU.
• How it Works: The owner sees that the "Footwear" category had a huge sales week. They right-click "Footwear" and drill through to an inventory report that is instantly filtered to show only footwear SKUs. They can now see exactly which specific shoe models are flying off the shelves and decide whether to reorder stock.

Final Thoughts

Mastering the cross-report drillthrough feature in Power BI is a surefire way to make your reports more professional, organized, and truly useful for end-users. By connecting summary-level dashboards to granular, detailed reports, you create an intuitive and seamless analytical journey, allowing anyone to move from "what happened" to "why it happened" in a matter of seconds.

While features like this in Power BI are powerful, setting them up still requires time, technical attention, and ensuring your data models are perfectly aligned. This is one of the areas where we felt a new approach was needed. With Graphed, we automate the hard parts. You can connect your marketing and sales data sources like Google Analytics, Shopify, and Salesforce in just a few clicks. Then, simply ask questions in natural language like, "Show me a dashboard of my top-selling product categories from Shopify" or "Compare my Facebook Ads spend vs Google Ads spend," and our AI builds a real-time, interactive dashboard for you, no manual configuration needed.