Card and multi-row card in Power BI - Dashboard Guide

Dashboard Mode - Card and multi-row card

Dashboard Goal

Show total sales and detailed sales by product category to understand overall performance and category contributions.

Sample Data

Order ID	Product Category	Sales Amount
1001	Electronics	250
1002	Furniture	450
1003	Electronics	300
1004	Clothing	150
1005	Furniture	200
1006	Clothing	100
1007	Electronics	400

Dashboard Components

1. Total Sales Card

Type: Card

Formula: Total Sales = SUM('Sales'[Sales Amount])

Result: 1850

This card shows the total sales amount from all orders.

2. Sales by Product Category Multi-Row Card

Type: Multi-row card

Formula: Sales by Category = SUM('Sales'[Sales Amount]) grouped by 'Sales'[Product Category]

Result:

• Electronics: 950
• Furniture: 650
• Clothing: 250

This multi-row card lists sales totals for each product category.

Dashboard Layout

+----------------------+------------------------------+
| Total Sales Card     | Sales by Product Category     |
| (shows 1850)        | Multi-row card listing sales  |
|                      | by category                   |
+----------------------+------------------------------+

Interactivity

A slicer for Product Category can filter both the Total Sales Card and the Multi-Row Card. Selecting a category updates the total sales to show only that category's sales and updates the multi-row card to show only the selected category's sales.

Self Check

If you add a filter selecting Furniture category, what updates occur?

• The Total Sales Card updates to show 650.
• The Multi-Row Card updates to show only Furniture: 650.

Key Result

Dashboard showing total sales and sales by product category using card and multi-row card visuals.

Practice

1. What is the main purpose of a Card visual in Power BI?

easy

A. To display a single important number clearly

B. To show multiple rows of data with labels

C. To create interactive filters for reports

D. To display detailed tables with many columns

Solution

1. Step 1: Understand Card visual function

   A Card visual is designed to show one key number or metric clearly on a report.

2. Step 2: Compare with other visuals

   Unlike Multi-row Card or tables, Card focuses on a single value without labels or rows.

3. Final Answer:

   To display a single important number clearly -> Option A

4. Quick Check:

   Card = single number [OK]

Hint: Card shows one number only, not multiple rows [OK]

Common Mistakes:

• Confusing Card with Multi-row Card
• Thinking Card shows multiple values
• Assuming Card is for filtering

2. Which of the following is the correct way to add a measure to a Card visual in Power BI?

easy

A. Drag the measure field into the Tooltip area of the Card visual

B. Drag the measure field into the Axis area of the Card visual

C. Drag the measure field into the Legend area of the Card visual

D. Drag the measure field into the Values area of the Card visual

Solution

1. Step 1: Identify Card visual field well

   The Card visual uses the Values area to display the number from a measure or column.

2. Step 2: Understand other areas

   Axis and Legend are for charts, not Card. Tooltip shows info on hover but not main display.

3. Final Answer:

   Drag the measure field into the Values area of the Card visual -> Option D

4. Quick Check:

   Card uses Values area for measure [OK]

Hint: Card visual only needs measure in Values area [OK]

Common Mistakes:

• Putting measure in Axis or Legend by mistake
• Confusing Tooltip with main display
• Trying to add multiple fields to Card

3. Given a Multi-row Card visual showing these fields: Sales Amount, Order Count, and Customer Count, what will the visual display?

medium

A. One single number combining all three fields

B. Three separate numbers each with their field label

C. A table with rows and columns for each field

D. A chart plotting Sales Amount over time

Solution

1. Step 1: Understand Multi-row Card behavior

   Multi-row Card shows multiple measures or columns as separate numbers with labels stacked vertically.

2. Step 2: Compare with other visuals

   It does not combine numbers into one or create tables or charts.

3. Final Answer:

   Three separate numbers each with their field label -> Option B

4. Quick Check:

   Multi-row Card = multiple labeled numbers [OK]

Hint: Multi-row Card shows each field with label separately [OK]

Common Mistakes:

• Thinking Multi-row Card sums fields
• Confusing Multi-row Card with table or chart
• Expecting combined or plotted data

4. You added a measure to a Multi-row Card but it shows blank instead of the expected number. What is the most likely cause?

medium

A. The measure has a filter that returns no data

B. The Multi-row Card does not support measures

C. You added the measure to the Axis area instead of Values

D. The data source is not connected

Solution

1. Step 1: Check measure calculation

   If a measure returns blank, often it is because filters applied cause no data to match.

2. Step 2: Verify Multi-row Card support

   Multi-row Card supports measures in Values area; Axis area does not exist for it.

3. Step 3: Confirm data connection

   If data source was disconnected, all visuals would fail, not just one measure.

4. Final Answer:

   The measure has a filter that returns no data -> Option A

5. Quick Check:

   Blank measure = no data due to filter [OK]

Hint: Blank measure usually means no data after filters [OK]

Common Mistakes:

• Thinking Multi-row Card can't show measures
• Trying to add measure to wrong field well
• Ignoring data connection issues

5. You want to create a dashboard showing total sales, total customers, and average order value clearly. Which visual setup is best?

hard

A. Use three separate Card visuals, one for each metric

B. Use a table visual listing all sales transactions

C. Use one Multi-row Card visual with all three measures

D. Use a line chart plotting sales over time

Solution

1. Step 1: Identify the need for multiple metrics

   You want to show three key numbers clearly with labels, so multiple values in one place is ideal.

2. Step 2: Compare visual options

   Three Cards would work but take more space; Multi-row Card shows all three metrics stacked with labels compactly.

3. Step 3: Exclude other visuals

   Table shows raw data, line chart shows trends, not summary numbers.

4. Final Answer:

   Use one Multi-row Card visual with all three measures -> Option C

5. Quick Check:

   Multi-row Card = multiple labeled metrics [OK]

Hint: Multi-row Card fits multiple metrics with labels compactly [OK]

Common Mistakes:

• Using multiple Cards wasting space
• Choosing tables or charts instead of summary visuals
• Not labeling metrics clearly