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.