Card and multi-row card in Power BI - Deep Dive

Overview - Card and multi-row card

What is it?

Card and multi-row card are visual tools in Power BI used to display key numbers and summaries. A Card shows a single number, like total sales, clearly and simply. A Multi-row card shows multiple values or categories in a list format, each with its own number. Both help users quickly see important data without digging through tables.

Why it matters

These visuals exist to make data easy to understand at a glance. Without them, users would have to read complex tables or reports to find simple answers like total revenue or number of customers. Cards highlight key metrics instantly, saving time and helping better decisions. They turn raw numbers into clear insights anyone can grasp.

Where it fits

Before learning cards, you should know how to load data and create basic visuals in Power BI. After mastering cards, you can explore more advanced visuals like charts and slicers to build interactive dashboards. Cards are a foundational step in showing data summaries effectively.

Mental Model

Core Idea

Cards are like digital sticky notes that show one or a few important numbers clearly so you can focus on what matters most.

Think of it like...

Imagine a scoreboard at a sports game showing the current score in big numbers. A Card is like that scoreboard for your data, showing one key number. A Multi-row card is like a list of scores for different players or teams, each with their own number.

┌───────────────┐   ┌─────────────────────────────┐
│     Card      │   │      Multi-row Card          │
│  ┌─────────┐  │   │  ┌─────────┐  ┌─────────┐     │
│  │ 12345   │  │   │  │ Item A  │  │ 1000    │     │
│  └─────────┘  │   │  ├─────────┤  ├─────────┤     │
└───────────────┘   │  │ Item B  │  │ 2500    │     │
                    │  ├─────────┤  ├─────────┤     │
                    │  │ Item C  │  │ 4000    │     │
                    │  └─────────┘  └─────────┘     │
                    └─────────────────────────────┘

Build-Up - 7 Steps

1

Foundation

Understanding the Card Visual

Concept: Introduce the Card visual as a way to show a single important number from your data.

In Power BI, a Card visual displays one number clearly. For example, you can show total sales by dragging the sales field to the Card. It automatically sums the values and shows the result in large text. This helps highlight one key metric on your report.

Result

You see a big number on your report representing the total of the chosen field.

Understanding that a Card focuses on one number helps you communicate the most important data point quickly.

2

Foundation

Exploring the Multi-row Card Visual

Concept: Learn how the Multi-row card shows multiple values with their numbers in a list format.

The Multi-row card lets you display several items and their numbers together. For example, showing sales by product category. You add the category field and the sales field to the Multi-row card. It lists each category with its sales number below it. This is useful for comparing multiple key figures side by side.

Result

You get a list of categories each with its own number, all visible in one visual.

Knowing how to show multiple related numbers together helps you tell a richer story with your data.

3

Intermediate

Formatting Cards for Clarity

🤔Before reading on: do you think changing font size or color affects how easy it is to read a Card? Commit to your answer.

Concept: Learn how to format Card visuals to improve readability and emphasis.

Power BI lets you change font size, color, background, and borders on Cards. For example, making the number bigger or changing its color to red for negative values. You can also add titles or data labels. These formatting options help make the Card stand out or fit your report style.

Result

Your Card looks clearer and matches the report’s design, making key numbers easier to spot.

Formatting is not just decoration; it guides the viewer’s attention to what matters most.

4

Intermediate

Using Cards with Measures and Calculations

🤔Before reading on: do you think Cards can show calculated values like averages or percentages? Commit to your answer.

Concept: Cards can display results of calculations, not just raw sums.

You can create measures in Power BI using DAX formulas, like average sales or profit margin. Then, place these measures on a Card visual. The Card will show the calculated result dynamically based on filters or slicers applied. This makes Cards powerful for showing key performance indicators.

Result

Your Card updates automatically to show calculated metrics, reflecting current data context.

Knowing Cards can show dynamic calculations unlocks their full potential for interactive reports.

5

Intermediate

Interacting with Cards in Reports

🤔Before reading on: do you think clicking a Card can filter other visuals on the page? Commit to your answer.

Concept: Cards can be interactive and affect other visuals in Power BI reports.

By default, Cards do not act as filters. However, clicking a category in a Multi-row card can filter charts or tables to show only that category’s data if the report interactions are configured accordingly. You can control this behavior in the report settings. This interactivity helps users explore data easily.

Result

Clicking on Card values changes other visuals, making the report interactive and user-friendly.

Understanding interactivity helps you design reports that invite exploration and deeper insights.

6

Advanced

Handling Large Data with Multi-row Cards

🤔Before reading on: do you think Multi-row cards can handle hundreds of rows well? Commit to your answer.

Concept: Multi-row cards have limits and best practices when showing many items.

Multi-row cards are best for showing a small list of important items. If you add too many rows, the visual becomes cluttered and hard to read. Instead, use filters or slicers to limit items shown. For large lists, consider tables or matrix visuals. This keeps reports clean and usable.

Result

Your report remains clear and performant by showing only relevant data in Multi-row cards.

Knowing when to limit data in Multi-row cards prevents overwhelming users and keeps reports effective.

7

Expert

Optimizing Cards for Performance and Usability

🤔Before reading on: do you think complex measures on Cards can slow down report loading? Commit to your answer.

Concept: Advanced users optimize Cards by simplifying measures and managing visual interactions.

Complex DAX measures on Cards can slow report performance, especially with large datasets. Experts optimize by pre-aggregating data, using variables in DAX, or limiting filters. Also, controlling cross-filtering behavior avoids unnecessary recalculations. These techniques keep Cards responsive and reports smooth.

Result

Your Cards load quickly and interact smoothly even with complex data and calculations.

Understanding performance trade-offs helps you build professional reports that scale well.

Under the Hood

Cards in Power BI retrieve data from the model by evaluating the field or measure assigned. For a Card, Power BI calculates a single scalar value, like a sum or average, based on current filters. For Multi-row cards, Power BI fetches multiple rows and their values, then renders them as a list. The visuals use the VertiPaq engine for fast in-memory calculations and rendering.

Why designed this way?

Cards were designed to provide a simple, focused way to highlight key numbers without distractions. The single-value Card keeps attention on one metric, while Multi-row cards allow showing related values together. This design balances clarity and flexibility, avoiding clutter while supporting interactivity.

┌─────────────┐       ┌───────────────┐       ┌───────────────┐
│ Data Model  │──────▶│ DAX Engine    │──────▶│ Card Visual   │
│ (Tables)    │       │ (Calculations)│       │ (Render Text) │
└─────────────┘       └───────────────┘       └───────────────┘

For Multi-row Card:

┌─────────────┐       ┌───────────────┐       ┌─────────────────────┐
│ Data Model  │──────▶│ DAX Engine    │──────▶│ Multi-row Card Visual│
│ (Tables)    │       │ (Row Context) │       │ (Render List)       │
└─────────────┘       └───────────────┘       └─────────────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Do you think a Card can show multiple numbers at once? Commit yes or no.

Common Belief: A Card can display several numbers side by side like a table.

Reality: A Card shows only one number at a time. To show multiple numbers, use a Multi-row card or other visuals.

Why it matters: Trying to show multiple numbers on a Card leads to confusion and poor report design.

Quick: Do you think formatting a Card changes the underlying data? Commit yes or no.

Common Belief: Changing font size or color in a Card changes the data values.

Reality: Formatting only changes how the number looks, not the data itself.

Why it matters: Misunderstanding this can cause unnecessary data changes or errors.

Quick: Do you think Multi-row cards perform well with thousands of rows? Commit yes or no.

Common Belief: Multi-row cards can handle very large lists without issues.

Reality: Multi-row cards become slow and cluttered with too many rows; better to use tables or filters.

Why it matters: Ignoring this leads to slow reports and poor user experience.

Quick: Do you think clicking a Card always filters other visuals? Commit yes or no.

Common Belief: Cards always act as filters when clicked.

Reality: Cards can be set to filter or not; interactivity depends on report settings.

Why it matters: Assuming default behavior can cause unexpected report interactions.

Expert Zone

1

Cards can display measures that use complex DAX logic, but performance depends on measure optimization.

2

Multi-row cards respect row context and can show dynamic lists that change with slicers or filters.

3

You can customize tooltips on Cards to provide extra info without cluttering the visual.

When NOT to use

Avoid Cards when you need to show trends or comparisons over time; use line or bar charts instead. For large lists, prefer tables or matrix visuals. When detailed data exploration is needed, Cards are too simple.

Production Patterns

Professionals use Cards on dashboards to highlight KPIs like total revenue or customer count. Multi-row cards often show top categories or segmented metrics. They are combined with slicers and filters for interactive drill-downs.

Connections

KPI (Key Performance Indicator)

Cards are a common way to display KPIs in reports.

Understanding Cards helps you communicate KPIs clearly, which is essential for business decision-making.

Dashboard Design

Cards are foundational elements in dashboard layouts for summarizing data.

Knowing how to use Cards effectively improves dashboard clarity and user engagement.

User Interface Design

Cards follow UI principles of minimalism and focus to highlight important info.

Recognizing this connection helps you design visuals that are both functional and easy to understand.

Common Pitfalls

#1 Trying to show multiple numbers on a single Card visual.

Wrong approach:

Add multiple fields to a Card visual expecting all to show simultaneously.

Correct approach:

Use a Multi-row card visual to display multiple values with their labels.

Root cause:

Misunderstanding that a Card is designed for a single scalar value only.

#2 Overloading Multi-row cards with too many rows causing clutter.

Wrong approach:

Add a large category field with hundreds of unique values to a Multi-row card.

Correct approach:

Filter or limit the data to a manageable number of rows or use a table visual instead.

Root cause:

Not considering visual readability and performance limits of Multi-row cards.

#3 Assuming Cards automatically filter other visuals when clicked.

Wrong approach:

Expect Cards to always act as slicers without configuring interactions.

Correct approach:

Set visual interactions explicitly in Power BI to control filtering behavior.

Root cause:

Lack of knowledge about report interaction settings and default behaviors.

Key Takeaways

Cards show one key number clearly, making important data easy to spot.

Multi-row cards display multiple related numbers in a clean list format.

Proper formatting and interactivity enhance the usefulness of Cards in reports.

Cards are best for summaries, not detailed or large datasets.

Optimizing measures and interactions keeps Cards fast and user-friendly.