Table and matrix layouts in Power BI - Step-by-Step Guide

Introduction

Tables and matrices help you organize and show your data clearly. They let you see details and summaries side by side. This makes it easier to understand numbers and compare values.

When you want to list sales data by product and date in rows and columns.

When you need to show totals and subtotals for different categories.

When you want to compare values across regions and time periods.

When you want to drill down into data to see more details.

When you want to display data with row and column groups for better structure.

Steps

Step 1: Click

- Visualizations pane

The visualizations options open on the right side of the screen

Step 2: Select

- Table icon in Visualizations pane

A blank table visual appears on the report canvas

Step 3: Drag

- Fields pane → drag a field (e.g., Product Name) to the Values area in Visualizations pane

The table shows the selected field as a column with data listed

Step 4: Drag

- Additional fields (e.g., Sales Amount, Date) to the Values area

The table adds columns for each field showing their data side by side

Step 5: Select

- Matrix icon in Visualizations pane

A blank matrix visual appears on the report canvas

Step 6: Drag

- Fields pane → drag a field (e.g., Region) to Rows area, another field (e.g., Year) to Columns area, and a measure (e.g., Sales Amount) to Values area

The matrix shows data grouped by rows and columns with totals

Step 7: Click

- Matrix visual → Expand/Collapse buttons next to row groups

The matrix expands or collapses to show more or fewer details

Before vs After

Before

Report canvas is empty with no visuals

After

Table visual shows product names and sales amounts in columns; matrix visual shows sales grouped by region in rows and year in columns with totals

Settings Reference

Row headers

📍 Format pane → Row headers

Show or hide row labels in the table or matrix

Default: On

Column headers

📍 Format pane → Column headers

Show or hide column labels in the table or matrix

Default: On

Subtotals

📍 Format pane → Subtotals

Show or hide subtotal rows or columns in the matrix

Default: On

Grid

📍 Format pane → Grid

Control the visibility of lines between cells for clarity

Default: Show grid lines

Values

📍 Format pane → Values

Customize how the data values look in the table or matrix

Default: Standard font and colors

Common Mistakes

Dragging fields only to Values area when using matrix

This shows data but misses grouping by rows or columns, losing structure

Drag fields to Rows and Columns areas to create groups and see summaries

Turning off row headers without understanding

This hides important labels, making data hard to read

Keep row headers on unless you have a specific reason to hide them

Not using expand/collapse buttons in matrix

You miss the ability to drill down or up in grouped data

Use expand/collapse buttons to explore data details easily

Summary

Tables and matrices organize data into rows and columns for easy reading.

Use tables for simple lists and matrices for grouped data with totals.

Remember to place fields correctly in Rows, Columns, and Values areas for best layout.

Practice

1. What is the main difference between a Table and a Matrix visual in Power BI?

easy

A. A Table can only show numbers, but a Matrix can show text and numbers.

B. A Table shows data in rows and columns without grouping, while a Matrix can group data and show subtotals.

C. A Matrix cannot display totals, but a Table can.

D. A Table automatically creates charts, but a Matrix does not.

Solution

1. Step 1: Understand Table layout

   A Table visual displays data simply in rows and columns without grouping or subtotals.

2. Step 2: Understand Matrix layout

   A Matrix allows grouping by rows and columns and can show subtotals and drill-downs.

3. Final Answer:

   A Table shows data in rows and columns without grouping, while a Matrix can group data and show subtotals. -> Option B

4. Quick Check:

   Table vs Matrix grouping = A Table shows data in rows and columns without grouping, while a Matrix can group data and show subtotals. [OK]

Hint: Remember: Matrix groups data; Table just lists it [OK]

Common Mistakes:

• Thinking Tables can group data like Matrices
• Believing Matrices cannot show totals
• Confusing data types shown in Tables vs Matrices

2. Which of the following is the correct way to add a subtotal in a Matrix visual in Power BI?

easy

A. Use a slicer to filter subtotal values.

B. Add a calculated column with subtotal values in the data table.

C. Enable the 'Subtotals' option in the Format pane under 'Row headers'.

D. Subtotals are added automatically and cannot be controlled.

Solution

1. Step 1: Locate subtotal settings in Matrix

   In Power BI, subtotals for rows or columns are controlled in the Format pane under 'Row headers' or 'Column headers'.

2. Step 2: Enable subtotals option

   Turning on the 'Subtotals' toggle adds subtotal rows or columns in the Matrix visual.

3. Final Answer:

   Enable the 'Subtotals' option in the Format pane under 'Row headers'. -> Option C

4. Quick Check:

   Subtotal toggle in Format pane = Enable the 'Subtotals' option in the Format pane under 'Row headers'. [OK]

Hint: Subtotals toggle is in Format pane, not data model [OK]

Common Mistakes:

• Trying to add subtotals via calculated columns
• Assuming subtotals appear without enabling them
• Using slicers to control subtotals

3. Given a Matrix visual with 'Category' in Rows and 'Sales' in Values, what will happen if you add 'Region' to Columns?

medium

A. The Matrix will show Sales grouped by Category and Region with subtotals for each Region.

B. The Matrix will only show Sales by Region, ignoring Category.

C. The Matrix will show a flat list of Sales without grouping.

D. Adding Region to Columns will cause an error.

Solution

1. Step 1: Understand Matrix layout with Rows and Columns

   Rows group data vertically, Columns group data horizontally, creating a grid showing intersections.

2. Step 2: Adding Region to Columns groups Sales by Category (rows) and Region (columns)

   This creates a matrix showing Sales values for each Category-Region pair with subtotals per Region.

3. Final Answer:

   The Matrix will show Sales grouped by Category and Region with subtotals for each Region. -> Option A

4. Quick Check:

   Matrix grouping by Rows and Columns = The Matrix will show Sales grouped by Category and Region with subtotals for each Region. [OK]

Hint: Rows group vertically, Columns group horizontally in Matrix [OK]

Common Mistakes:

• Thinking adding columns removes row grouping
• Expecting flat list instead of grouped matrix
• Assuming error occurs when adding columns

4. You created a Matrix visual but subtotals are not showing. What is the most likely reason?

medium

A. Matrix visuals never show subtotals.

B. The data source does not have numeric values.

C. You added too many fields to the Rows area.

D. The 'Subtotals' option in the Format pane is turned off.

Solution

1. Step 1: Check Format pane settings for subtotals

   Subtotals must be enabled in the Format pane; if off, subtotals won't appear.

2. Step 2: Verify data type and fields

   Numeric values are needed for meaningful subtotals, but subtotals can still show if enabled.

3. Final Answer:

   The 'Subtotals' option in the Format pane is turned off. -> Option D

4. Quick Check:

   Subtotals toggle off = missing subtotals [OK]

Hint: Check Format pane subtotals toggle first [OK]

Common Mistakes:

• Assuming subtotals show automatically
• Blaming data type without checking settings
• Thinking Matrix can't show subtotals

5. You want to create a report showing monthly sales by product category with subtotals for each category and a grand total. Which layout and settings should you use?

hard

A. Use a Matrix visual with 'Month' in Columns, 'Category' in Rows, and enable subtotals for rows and columns.

B. Use a Table visual with 'Month' and 'Category' in columns and enable subtotals in the data model.

C. Use a Matrix visual with 'Category' in Columns, 'Month' in Rows, and disable subtotals.

D. Use a Table visual with only 'Sales' values and add subtotals manually.

Solution

1. Step 1: Choose Matrix for grouping and subtotals

   Matrix supports grouping by rows and columns and shows subtotals and grand totals.

2. Step 2: Place 'Month' in Columns and 'Category' in Rows

   This layout shows months horizontally and categories vertically, making subtotals clear.

3. Step 3: Enable subtotals for rows and columns

   Turn on subtotals in Format pane to show category subtotals and grand totals.

4. Final Answer:

   Use a Matrix visual with 'Month' in Columns, 'Category' in Rows, and enable subtotals for rows and columns. -> Option A

5. Quick Check:

   Matrix with grouping and subtotals = Use a Matrix visual with 'Month' in Columns, 'Category' in Rows, and enable subtotals for rows and columns. [OK]

Hint: Matrix + grouping + subtotals = best for grouped summaries [OK]

Common Mistakes:

• Using Table when subtotals needed
• Disabling subtotals accidentally
• Swapping rows and columns causing confusing layout