How to Make Cards Interactive in Power BI

Tired of your Power BI cards staring back at you with static, unchanging numbers? While cards are great for displaying key performance indicators (KPIs), they often lack the context and depth of more complex visuals. This article will show you how to turn those basic cards into dynamic, interactive elements that invite exploration using tooltips, bookmarks, and a little bit of DAX magic.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Making Cards Interactive?

Static numbers tell you the "what" (e.g., total sales are $10M), but they rarely tell you the "why." Interactive cards transform a simple KPI into a starting point for analysis. Instead of just displaying a number, an interactive card can:

• Provide Instant Context: Let users see a trend or a breakdown behind the KPI without having to navigate to another report page.
• Save Valuable Canvas Space: Pack more information into a single visual, reducing clutter and a "busy" report design.
• Improve User Engagement: Encourage users to hover, click, and explore the data, leading to deeper understanding and more informed decisions.

Ultimately, it’s about making your reports more intuitive and insightful, guiding your audience from a high-level metric to the details that matter in just a click or a hover.

Method 1: Add Rich Context with Report Tooltips

One of the easiest yet most powerful ways to enhance a card is by adding a custom report tooltip. Instead of the default black box showing the value, you can design a custom mini-report that appears on hover, displaying charts, tables, or other visuals to add context.

Imagine a card showing "Total Website Sessions." With a report tooltip, hovering over that number could instantly reveal a line chart of session trends over the past 30 days and a pie chart breaking down sessions by device type. Here's how to build it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Creating Report Tooltips

Step 1: Create a Dedicated Tooltip Page

First, you need a separate page in your Power BI file that will serve as the tooltip template.

1. Click the '+' button at the bottom of the screen to create a new page. Give it a descriptive name, like "Sales Tooltip."
2. With the new page selected (and no visuals on it), go to the Format pane.
3. Expand the Page information section.
4. Flick the Allow use as tooltip switch to On.
5. Expand the Canvas settings section. Under Type, select Tooltip from the dropdown. This automatically resizes the canvas to a small, tooltip-friendly size.

Your page is now officially a tooltip template, hidden from normal report navigation.

Step 2: Design Your Tooltip Visual

Now, add the visuals you want to appear when a user hovers over the main card. Drag the relevant data fields onto your tiny tooltip canvas.

• For a "Total Sales" card: You could add a small line chart showing sales over time and a clustered bar chart showing sales by product category.
• For a "Customer Count" card: A map showing customers by state or a table listing your top 10 customers by revenue would be incredibly useful.

Pro Tip: Keep your tooltip design simple. Too much information will make it feel cluttered and hard to read. Focus on one or two supplementary visuals that directly relate to the main KPI.

Step 3: Connect the Tooltip to Your Card Visual

Finally, let's link this new tooltip page to your card on the main report.

1. Navigate back to your main report page.
2. Select the card visual you want to make interactive.
3. In the Format pane, find the General tab, then expand the Tooltips section.
4. Change the Type from Default to Report page.
5. In the new dropdown that appears for Page, select the tooltip page you just created (e.g., 'Sales Tooltip').

That's it! Now, when you hover your mouse over the card, your beautifully designed, context-rich tooltip will appear, providing an immediate layer of insight.

Method 2: Create a Drill-Down Effect with Bookmarks and Buttons

Sometimes, a simple hover isn't enough. You want to give users the ability to "click in" to a more detailed view and then return to the summary view easily. This is where bookmarks and buttons come in. This technique allows you to toggle the visibility of different visuals, creating a seamless drill-down experience on the same page.

Let's say you have a card showing "Average Deal Size." With this method, a user could click an "info" icon on the card, which would make the card disappear and reveal a detailed table of closed deals for the selected period.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Using Bookmarks for Interactivity

Step 1: Set Up Your Visuals and Panes

First, layer the visuals you want to toggle. Place your primary card on the report. Then, place your detailed visual (like a table or chart) directly on top of it or right next to it. Don't worry about the overlap for now.

Next, open the necessary panes by going to the View tab in the ribbon:

• Click Bookmarks to open the Bookmarks pane.
• Click Selection to open the Selection pane.

The Selection pane lists all the objects on your report page, allowing you to control their visibility by clicking the eye icon next to each one.

Step 2: Create the "Default View" Bookmark

This bookmark will represent the initial state of your report, with only the main KPI card visible.

1. In the Selection pane, hide the detailed visual (click the eye icon next to its name) and make sure your summary card is visible.
2. In the Bookmarks pane, click Add. A new bookmark will be created.
3. Rename this bookmark something intuitive, like "Hide Details."
4. Important: Click the three dots (...) next to the bookmark name and uncheck Data. This ensures that the bookmark only controls the visibility of objects and doesn't mess with any filters or slicers the user has selected.

Step 3: Create the "Detailed View" Bookmark

Now create the state where the detailed view is shown.

1. In the Selection pane, do the opposite of the previous step: hide your summary card and show the detailed visual.
2. In the Bookmarks pane, click Add again.
3. Rename this new bookmark to "Show Details" and remember to uncheck the Data option.

Step 4: Connect Buttons to Your Bookmarks

Now, let's add buttons to switch between these two states.

1. Go to the Insert tab, click Buttons, and choose an icon that makes sense (like a right arrow or an 'i' for information). Place this button near your summary card.
2. Select the button. In the Format pane, go to Button > Action.
3. Turn the Action toggle on. For the Type, select Bookmark. For the Bookmark, choose "Show Details."
4. Now, insert a "Back" button (or a left arrow) and place it on your detailed visual.
5. Select the "Back" button, turn on its Action, set the Type to Bookmark, and set the Bookmark to "Hide Details."

Now you can test it! Hold CTRL and click the buttons in Power BI Desktop (or just click them in the Power BI service). You've successfully created an interactive toggle that feels like drilling down into your data.

Method 3: Create Dynamic Card Titles with DAX

Another subtle but effective way to make cards interactive is to have their titles change based on what a user selects in a slicer. If you have a slicer for different years, your "Total Revenue" card title can automatically update to read "Total Revenue for 2023" when a user selects that year.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Dynamic Titles

Step 1: Write a DAX Measure for the Title

DAX (Data Analysis Expressions) is the formula language for Power BI. We'll use a simple DAX measure to create our dynamic title.

1. In the Home tab, click New measure.
2. In the formula bar, enter a formula like this. This example assumes you have an 'Order Date' table with a 'Year' column:

Dynamic Sales Title = "Total Sales For " & SELECTEDVALUE('Order Date'[Year], "All Years")

The SELECTEDVALUE function checks if a single value has been selected in the 'Year' column. If it has, it returns that value (e.g., "2023"). If nothing or multiple years are selected, it returns the alternative text, "All Years."

Step 2: Connect the Measure to the Card's Title

1. Select your card visual.
2. In the Format pane, go to the General tab and expand the Title section.
3. Hover over the Text field and click the fx (Conditional formatting) button.
4. In the dialog box that pops up, choose Field value for the Format style.
5. Under What field should we base this on?, find and select the DAX measure you just created (Dynamic Sales Title).
6. Click OK.

Now when you use your 'Year' slicer, the card's title will instantly update to reflect your selection, providing clear and immediate context to your users.

Final Thoughts

By moving beyond static displays, you can make your Power BI reports feel less like spreadsheets and more like applications. Transforming your cards with clever tooltips for on-hover context, bookmarks for drill-down functionality, and dynamic DAX titles for slicer-aware labeling lets users get more value out of your data with every click and hover.

While mastering these techniques in Power BI is a powerful skill, it often involves learning the nuances of DAX, format panes, and visual layers. We built Graphed because we believe getting insights shouldn't require a steep learning curve. You can connect your data sources in a few clicks and build real-time, interactive dashboards just by describing what you want to see - turning hours of report building into a few seconds of simple conversation.