Card and multi-row card in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows sales amounts for three products.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	200

Formula Trace

Total Sales = SUM(Sales[Sales])

Step 1: SUM(Sales[Sales])

Step 2: 100 + 150 + 200

Cell Reference Map

   A        B
1 Product  Sales
2 Apples   100
3 Bananas  150
4 Cherries 200

Arrows: SUM reads B2, B3, B4

The formula references the Sales column cells B2, B3, and B4 to calculate total sales.

Result

   A        B        C
1 Product  Sales    Card
2 Apples   100      450
3 Bananas  150
4 Cherries 200

Multi-row card would show:
Product: Apples, Sales: 100
Product: Bananas, Sales: 150
Product: Cherries, Sales: 200

The Card visual shows the total sales value 450. The Multi-row card lists each product with its sales amount.

Sheet Trace Quiz - 3 Questions

What does the Card visual display in this example?

A The average sales value

B The sales value of the first product only

C The sum of all sales values

D The number of products

Key Result

SUM aggregates all values in a column to produce a single total.

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