Card and multi-row card in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Card visual in Power BI?

A Card visual shows a single number or value clearly, like total sales or count of customers. It's great for highlighting one key metric.

beginner

How does a Multi-row Card differ from a Card visual?

A Multi-row Card shows multiple values or fields in a list format, each with its own label and value, unlike a Card which shows only one value.

intermediate

Can you use a Multi-row Card to display text fields?

Yes, Multi-row Cards can display text fields along with numbers, making it useful for showing details like names and statuses together.

beginner

What is a good use case for a Card visual?

Use a Card to show a single important number, like total revenue, total customers, or average rating, so it stands out on your report.

intermediate

How can you format a Card visual to improve readability?

You can change font size, color, background, and add data labels or units to make the number clear and easy to read.

What does a Card visual in Power BI display?

A A single summarized value

B Multiple rows of data

C A detailed table

D A chart with bars

A Card visual shows one key number clearly, like total sales.

Which visual would you use to show several fields like name, status, and score together?

A Line Chart

B Card

C Pie Chart

D Multi-row Card

Multi-row Card displays multiple fields in a list format.

Can a Card visual show text values?

A Yes, but only one text value

B No, it only shows one numeric value

C Yes, it shows multiple text fields

D No, it only shows charts

A Card can show one text or numeric value, but not multiple fields.

What is a key benefit of using a Card visual?

A Shows detailed data tables

B Creates interactive filters

C Highlights one important number clearly

D Displays multiple charts

Cards highlight a single important metric clearly on a report.

How can you improve the look of a Card visual?

A Add multiple rows

B Change font size and color

C Add a pie chart

D Use it to show text tables

Formatting font size and color makes the Card number easier to read.

Explain the difference between a Card and a Multi-row Card visual in Power BI.

Think about how many values each visual shows and their layout.

Describe a scenario where you would use a Card visual and how you would format it for clarity.

Focus on showing one important number clearly.

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