Cards, Tables and Matrices
Cards, tables, and matrix visuals are essential Power BI components for presenting business information. Cards highlight important numbers, tables display detailed records, and matrices organize information into grouped rows and columns.
Learning Objectives
- Understand the purpose of card visuals.
- Create single-value and multi-value card displays.
- Build tables for detailed business records.
- Use matrices to summarize data by rows and columns.
- Apply formatting to improve readability.
- Choose the right visual for a reporting requirement.
1. Understanding Cards, Tables and Matrices
Each visual serves a different reporting purpose. A card provides a quick summary, a table presents individual records, and a matrix summarizes information using a row-and-column structure.
Visual Comparison
2. Card Visuals
A card displays a prominent value such as total sales, profit, order count, or customer count. Cards are commonly placed at the top of a report page to communicate important performance indicators.
Examples of Card Metrics
How to Create a Card
- Select an empty area on the report canvas.
- Choose the Card visual from the Visualizations pane.
- Drag a measure or suitable numeric field into the visual's data field well.
- Verify that the value is summarized correctly.
- Open the formatting options to configure the title, callout value, labels, and background.
- Resize and position the card to fit the report layout.
3. Creating a Sales Measure for a Card
Suppose your model contains a table named Sales with a numeric column named SalesAmount. You can create a measure to calculate total sales.
DAX Measure
Total Sales = SUM(Sales[SalesAmount])
Add the Total Sales measure to a card. The card displays the total for the current filter context, so its value can change when users interact with report filters and slicers.
4. Table Visuals
A table displays data in rows and columns. It is useful when users need to inspect individual records, compare several fields, or verify the detail behind a summary value.
Example: Product Sales Table
| Product | Category | Units Sold | Sales Amount |
|---|---|---|---|
| Laptop | Electronics | 25 | 50,000 |
| Phone | Electronics | 35 | 35,000 |
| Desk | Furniture | 12 | 24,000 |
| Chair | Furniture | 20 | 16,000 |
How to Create a Table
- Select the Table visual.
- Add the required columns or measures to the visual.
- Arrange the fields in the desired order.
- Check numeric aggregation and column formatting.
- Apply sorting and conditional formatting if required.
- Adjust column widths so the information is easy to read.
When to Use a Table
- When users need to see individual records.
- When several attributes must be displayed together.
- When users need to inspect the detail behind a summary.
- When exact values are more important than visual patterns.
5. Matrix Visuals
A matrix summarizes data across row groups and column groups. It is similar to a pivot table and can support hierarchical grouping, subtotals, and drill-down interactions.
Example: Sales by Region and Quarter
| Region | Q1 Sales | Q2 Sales | Total Sales |
|---|---|---|---|
| North | 20,000 | 25,000 | 45,000 |
| South | 18,000 | 22,000 | 40,000 |
| West | 15,000 | 19,000 | 34,000 |
| Grand Total | 53,000 | 66,000 | 119,000 |
How to Create a Matrix
- Select the Matrix visual.
- Place a grouping field, such as Region, in Rows.
- Place a time period, such as Quarter, in Columns.
- Place a measure, such as Total Sales, in Values.
- Configure subtotals, grand totals, and row or column formatting.
- Test expand and collapse options if the matrix contains a hierarchy.
6. Table vs. Matrix
| Feature | Table | Matrix |
|---|---|---|
| Structure | Flat rows and columns | Grouped rows and columns |
| Hierarchy | Limited hierarchical presentation | Supports expandable row hierarchies |
| Subtotals | Not the main grouping feature | Supports grouped subtotals and grand totals |
| Best use | Detailed record inspection | Cross-group summaries and comparisons |
7. Formatting and Conditional Formatting
Formatting helps users identify important values and read data efficiently. Power BI provides formatting controls for titles, labels, borders, gridlines, backgrounds, and numeric display.
- Use descriptive titles for cards, tables, and matrices.
- Format currency values consistently.
- Use appropriate decimal places and percentage formats.
- Keep column headers concise.
- Apply conditional formatting to highlight meaningful differences.
- Use restrained colors to preserve readability.
Illustration: Conditional Formatting
Conditional formatting can highlight values according to rules, thresholds, or data-driven color scales. The rules should have a clear business meaning.
8. Practice Activity
Scenario: Retail Performance Report
Create a report page that helps a manager understand overall performance and inspect product-level details.
Tasks
- Create a card for Total Sales.
- Create another card for Total Orders.
- Build a table containing Product, Category, Units Sold, and Sales Amount.
- Build a matrix showing Region in Rows, Quarter in Columns, and Total Sales in Values.
- Format sales amounts as currency or an appropriate numeric format.
- Apply conditional formatting to highlight high and low sales values.
- Compare the table and matrix and explain when each is more useful.
9. Knowledge Check
Question 1: Which visual is most suitable for highlighting one important KPI?
A. Card
B. Matrix
C. Detailed table only
Question 2: Which visual supports grouped row and column summaries?
A. Card
B. Matrix
C. Pie chart
Question 3: What is a common purpose of conditional formatting?
A. Highlighting meaningful values or differences
B. Creating a new data source automatically
C. Replacing all report measures
Show Answers
- Question 1: A — Card.
- Question 2: B — Matrix.
- Question 3: A — Highlighting meaningful values or differences.
Summary
In this lesson, you learned how to use cards to highlight key business metrics, tables to display detailed records, and matrices to summarize information across grouped rows and columns. You also practised formatting values and applying conditional formatting to make important information easier to identify.
Choose a visual according to the reporting requirement. Cards communicate key figures, tables support detailed inspection, and matrices help users compare grouped data. Consistent formatting and meaningful labels improve report readability.