How to Add Drill Through in Card in Power BI

Power BI cards are fantastic for displaying key performance indicators (KPIs) at a glance, but they lack a direct, built-in drillthrough function. This can be frustrating when you want to click on a summary number like "Total Sales" and instantly see the detailed transactions that a table or chart would offer. This guide will show you a powerful and clean workaround to add drillthrough functionality to your Power BI cards, making your dashboards more interactive and insightful.

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

Why Would You Want a Drillthrough on a Card Visual?

In Power BI, drillthrough is a feature that lets users navigate from a summary visual to another page in the report, which is filtered to show the specific details related to the data they selected. For example, you might click on the "USA" bar in a sales by country chart, and a drillthrough would take you to a new page showing sales details just for the USA.

But what about cards? Cards show a single, aggregated value, like total revenue, number of website visitors, or new leads this month. The benefit of adding a drillthrough is to allow users to investigate that number further without cluttering the main dashboard. They can click on the "Total Revenue" card and go directly to a detailed report page showing all individual sales that make up that total. It transforms a static KPI into a dynamic gateway for deeper analysis.

This functionality isn't available out of the box for Card visuals. You simply can't right-click a card and see a "Drillthrough" option. However, we can create this experience seamlessly using a clever combination of other Power BI features.

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 Method: Layering a Transparent Button Over Your Card

The solution involves placing an invisible button on top of your Card visual. We will then configure this button's "Action" to be the drillthrough link to our desired detail page. When a user thinks they are clicking on the card, they are actually clicking the transparent button laid over it, which triggers the navigation and provides the exact user experience we're looking for.

To make this work, you'll need three key ingredients:

• Your source page (the main dashboard with the card).
• A destination page (the detailed report page you want to see).
• A blank button to trigger the action.

Step 1: Set Up Your Drillthrough Destination Page

First, you need to prepare the page that users will land on after clicking the card. This page needs to be explicitly enabled as a drillthrough target. Let's imagine you have a detail page named "Sales Details" that contains a table of all individual transactions.

1. Navigate to your "Sales Details" page in Power BI Desktop.
2. Make sure no visuals are selected. Click on the blank canvas area of the report. The Visualizations pane will now show settings for the page itself.
3. Look for the section at the bottom of the Visualizations pane labeled "Add drill-through fields here."
4. From your Fields pane, drag the measure or column you want to be able to filter by into this drill-through box. This is the crucial step. For a universal drillthrough from a total sales card, you might use a field that is relevant to the overall context, like [Region] or [Date]. This tells Power BI that pages can navigate to this page based on that field.

When you add a field to the drillthrough well, Power BI automatically does two things:

• It designates this page as a drillthrough destination.
• It adds a "Back" button icon to the top-left of your report page. This button is pre-programmed to take the user back to the originating page they just came from.

You can customize the look and feel of this back button by selecting it and modifying its properties in the Format pane, just like any other button.

Step 2: Create the Card Visual and Button Overlay on Your Source Page

Now, let's head back to your main dashboard page - the one where your KPI card lives. Here, we'll build the visual components.

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

Create and Format the Card

First, create the Card visual as you normally would. Go to the Insert tab, select Card, and drag your primary measure (like "Total Sales" or "Total Sessions") into the Fields well. Position and format the card to fit your dashboard's design.

Create and Position the Button

1. Go to the Insert tab in the ribbon.
2. Click on Buttons and select Blank. A new, shapeless button will appear on your canvas.
3. Drag this button and place it directly on top of your Card visual.
4. Resize the button by dragging its edges so that it completely covers the card. The goal is to make sure anywhere the user clicks on the card, they are interacting with the button instead.

Make the Button Invisible

With the button selected, you need to make it completely transparent so only the card underneath is visible.

1. Open the Format button pane on the right.
2. Expand the Style section.
3. Under Fill, turn the toggle On, select a color (it doesn't matter which), and drag the Transparency slider to 100%.
4. Turn the Border toggle Off.
5. Make sure anything else that could be visible, like Icon or Shadow, is also turned off. The button should now be completely invisible on your report canvas, though you can still select it.

A good way to manage this overlay is by using the Selection Pane (found under the View tab). This pane lists all the objects on your page, allowing you to easily select, hide, or reorder the button and card. Ensure the button layer is positioned above the card layer.

Step 3: Configure the Button's Drillthrough Action

This is where the magic happens. We'll tell the invisible button to act as a drillthrough trigger.

1. With your invisible button selected, go back to the Format button pane.
2. Turn the Action toggle On.
3. Expand the Action settings. For the Type, select Drill through from the dropdown menu.
4. For the Destination, select your target page from the dropdown - in our example, this would be "Sales Details."
5. The Tooltip field is incredibly important for user experience. Type in a helpful instruction like, "Click to see detailed transactions." Now, when a user hovers their mouse over the card, this tooltip will appear, signaling that the visual is interactive.

By default, the drillthrough action is enabled. If you want to only enable it under certain conditions (e.g., if a slicer is selected), you can use conditional formatting for the "Destination," but for this setup, keeping it always enabled is usually what you want.

Step 4: Test Your New Interactive Card

You're all set up! To test the functionality within Power BI Desktop, you need to hold down the Ctrl key and then click on your card (or rather, the invisible button on top of it).

You should instantly be navigated to your "Sales Details" page. Notice that if you've made selections on your source page using slicers (for example, filtering by a specific year or product category), that context is automatically passed to the drillthrough page. The data on the details page will be filtered accordingly, which is exactly why this technique is so powerful.

Once you publish the report to the Power BI service, your users will be able to click the card directly (no Ctrl key needed) for a smooth and intuitive experience.

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 Better User Experience

While the transparent button is a great trick, a few small touches can make the experience even better for your end-users.

• Provide Hover Feedback: A completely invisible button gives zero feedback until the user hovers and sees the tooltip. Consider adding a subtle hover effect. With the button selected, go to the Style settings and find the On hover state. You could set the Fill to be black at 90% transparency. This way, when a user hovers over the card, it subtly darkens, visually confirming that it's a clickable element.
• Use Descriptive Tooltips: As mentioned, the tooltip is your best friend. Instead of the default "Ctrl + click here to view link," write something clear that tells the user what will happen next. "Click for a detailed breakdown of sales" is far better than generic text.
• Design a Logical Destination: Ensure the drillthrough page is well-designed and directly addresses the implied question the user has when clicking the KPI. If they click "Total Website Visitors," they should see details about visitor demographics, sources, or behavior - not a list of financial transactions. The flow should be intuitive.

Final Thoughts

Although Power BI doesn't offer a direct way to add drillthroughs to card visuals, the transparent button overlay method provides a simple, clean, and highly effective backdoor. By combining a few basic features, you can create a much more interactive and discoverable report, allowing users to move from high-level summaries to detailed insights with a single click.

Setting up these kinds of user-friendly features can involve many steps in tools like Power BI. Sometimes, you just want to get to the answers without becoming a dashboard architect. At Graphed, we've made data exploration much simpler. You can connect all your data sources - from Google Analytics to Salesforce - and then just ask questions in plain English. Instead of building buttons and drillthrough pages, you can ask "Show me total sales for last quarter" and follow it up with "Now show me the individual transactions for our top 5 customers." We give you the answers and the charts instantly, turning hours of report building into a 30-second conversation.