Card and multi-row card in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a quick summary dashboard showing total sales, total units sold, and average sales price per unit for the last quarter.

📊 Data: You have sales transaction data including Date, Product, Units Sold, and Sales Amount.

🎯 Deliverable: Create a Power BI report page with Card visuals for total sales and total units sold, and a Multi-row Card visual for average sales price per unit by product.

Sample Data

Date	Product	Units Sold	Sales Amount
2024-01-15	Widget A	10	200
2024-01-20	Widget B	5	150
2024-02-05	Widget A	8	160
2024-02-18	Widget C	12	360
2024-03-10	Widget B	7	210
2024-03-22	Widget C	6	180
2024-04-01	Widget A	9	180
2024-04-15	Widget B	4	120

1

Step 1: Filter data to include only sales from the last quarter (January to March 2024).

Apply a date filter on the Date column: Date >= DATE(2024,1,1) and Date <= DATE(2024,3,31).

Expected Result

Filtered data includes 6 rows from January to March 2024.

2

Step 2: Create a measure for Total Sales.

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

Expected Result

Total Sales measure sums to 1260 for filtered data.

3

Step 3: Create a measure for Total Units Sold.

Total Units Sold = SUM('Sales'[Units Sold])

Expected Result

Total Units Sold measure sums to 48 for filtered data.

4

Step 4: Create a measure for Average Sales Price per Unit.

Average Price per Unit = DIVIDE([Total Sales], [Total Units Sold])

Expected Result

Average Price per Unit calculates to 26.25.

5

Step 5: Create a Card visual and add the Total Sales measure to it.

Visual type: Card; Field: Total Sales

Expected Result

Card visual displays 1260.

6

Step 6: Create a Card visual and add the Total Units Sold measure to it.

Visual type: Card; Field: Total Units Sold

Expected Result

Card visual displays 48.

7

Step 7: Create a measure for Average Sales Price per Unit by Product.

Average Price per Unit by Product = DIVIDE(SUM('Sales'[Sales Amount]), SUM('Sales'[Units Sold]))

Expected Result

Calculates average price per unit for each product.

8

Step 8: Create a Multi-row Card visual and add Product and Average Price per Unit by Product measure.

Visual type: Multi-row Card; Fields: Product, Average Price per Unit by Product

Expected Result

Multi-row Card shows each product with its average price per unit: Widget A=20, Widget B=30, Widget C=30.

Final Result

-----------------------------
| Total Sales       |  1260  |
-----------------------------
| Total Units Sold  |   48   |
-----------------------------
| Average Price per Unit by Product |
| Widget A         |  20    |
| Widget B         |  30    |
| Widget C         |  30    |
-----------------------------

✓Total sales for the last quarter were $1,260.

✓A total of 48 units were sold in the last quarter.

✓Widget A has the lowest average price per unit at $20.

✓Widgets B and C have a higher average price per unit at $30.

Bonus Challenge

Add a slicer to the report to allow filtering the data by Product, updating all cards dynamically.

Show Hint

Use a slicer visual with the Product field and ensure all visuals interact with the slicer.