Card and multi-row card in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct use of a Card visual

You want to show the total sales amount as a single number on your Power BI report. Which visual should you use?

A Use a Card visual to display the total sales measure.

B Use a Multi-row Card visual to display the total sales measure.

C Use a Table visual to display the total sales measure.

D Use a Matrix visual to display the total sales measure.

💡 Hint

Think about which visual shows a single number clearly.

A Card visual is designed to show one single value, such as total sales, clearly and prominently. Multi-row Card shows multiple values, and Table or Matrix show detailed data.

❓ dax_lod_result

intermediate

Calculate total sales for a specific product category

Given the following DAX measure, what is the output if the current filter context is for the 'Bikes' category only?

Sales Bikes = CALCULATE(SUM(Sales[Amount]), Products[Category] = "Bikes")

Power BI

Sales Bikes = CALCULATE(SUM(Sales[Amount]), Products[Category] = "Bikes")

A Sum of sales amount only for 'Bikes' category in the current filter context.

B Sum of sales amount for all categories ignoring filters.

C Syntax error in the DAX expression.

D Sum of sales amount for 'Bikes' category ignoring current filters.

💡 Hint

CALCULATE changes filter context to the specified condition.

The CALCULATE function applies the filter Products[Category] = "Bikes" on top of the current filter context, so it sums sales only for Bikes category within the current filters.

🔧 Formula Fix

advanced

Why does the Multi-row Card show repeated values?

You created a Multi-row Card visual with the fields: Customer Name and Total Sales. But the visual shows repeated customer names with the same sales amount multiple times. What is the most likely cause?

A The measure Total Sales is not aggregated properly causing repeats.

B The Multi-row Card visual cannot show multiple fields together.

C The data model has duplicate rows for customers causing repeated values.

D The visual needs a slicer to filter unique customers.

💡 Hint

Think about what causes repeated rows in visuals.

If the data model contains duplicate rows for customers, the Multi-row Card will show repeated customer names with their sales. The visual can show multiple fields, and measures aggregate correctly by default.

🎯 Scenario

advanced

Best visual choice for showing multiple KPIs per customer

You want to display for each customer their total sales, total orders, and average order value in a single visual. Which visual is best suited for this in Power BI?

A Use a Pie Chart visual to show the three KPIs per customer.

B Use a Multi-row Card visual with the three measures and Customer Name field.

C Use a Line Chart visual to show the KPIs over time.

D Use a Card visual with all three measures combined into one measure.

💡 Hint

Think about which visual can show multiple values per category clearly.

The Multi-row Card visual can display multiple measures side by side for each category (customer). Card shows only one value, Pie and Line charts are for different purposes.

🧠 Conceptual

expert

Understanding filter context in Card vs Multi-row Card visuals

Which statement best explains how filter context affects Card and Multi-row Card visuals differently in Power BI?

A Multi-row Card visual cannot be filtered by slicers or report filters.

B Both Card and Multi-row Card visuals ignore filter context and show all data.

C Card visual applies filter context per row; Multi-row Card aggregates all data ignoring filters.

D Card visual shows a single aggregated value affected by filter context; Multi-row Card shows multiple rows each affected by filter context individually.

💡 Hint

Consider how each visual displays data and how filters apply.

The Card visual shows one aggregated value that changes with filter context. The Multi-row Card shows multiple rows, each filtered and aggregated according to the current filter context.

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