Table and matrix layouts in Power BI - Dashboard Guide

Dashboard Mode - Table and matrix layouts

Dashboard Goal

Understand sales performance by product and region using tables and matrix layouts to compare values clearly.

Sample Data

Region	Product	Sales	Quantity
North	Apples	100	50
North	Bananas	150	75
South	Apples	200	100
South	Bananas	120	60
East	Apples	180	90
East	Bananas	160	80
West	Apples	140	70
West	Bananas	130	65

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 1180
• Table: Sales by Region and Product
  Columns: Region, Product, Sales, Quantity
  Shows raw data rows for detailed view.
• Matrix: Sales Summary Matrix
  Rows: Region
  Columns: Product
  Values: Sum of Sales
  Formula for values: SUM(Sales[Sales])
  Shows sales totals by region and product in a grid layout for easy comparison.

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |                      |
|        1180          |                      |
+----------------------+    Sales by Region    |
|                      |    and Product Table  |
|                      |                      |
|                      |                      |
+----------------------+----------------------+
|                      Sales Summary Matrix   |
|                                              |
|                                              |
+----------------------------------------------+

Interactivity

A slicer for Region filters both the Table and Matrix components. Selecting a region updates the sales data shown in the table and the matrix to only that region's data. The Total Sales KPI card also updates to show the sum of sales for the selected region.

Self Check

If you add a filter for Region = South, which components update and what changes occur?

• Total Sales KPI: Updates to show 320 (200 + 120).
• Sales by Region and Product Table: Shows only rows where Region is South.
• Sales Summary Matrix: Shows sales only for South region with Apples = 200 and Bananas = 120.

Key Result

Dashboard shows total sales, detailed sales table, and sales summary matrix by region and product with interactive region filter.