Tables and Matrices0%

Tables and Matrices

Beginner12 min read•Updated: Jul 11, 2026

Tables and Matrices in Power BI

Reading Time: 8 Mins | Level: Beginner to Advanced

Table Visual: A flat, two-dimensional grid of rows and columns (similar to a standard Excel table).
Matrix Visual: The Power BI equivalent of an Excel PivotTable. Supports row hierarchies, column hierarchies, drill-down buttons ($+$ and $-$), stepped layouts, and conditional formatting.

Transform numbers into visual heatmaps:

Background Color: Shades cells from light to dark based on value magnitude.
Data Bars: Embeds mini horizontal bars directly inside numerical cells.
Icons: Displays red/yellow/green KPI indicators based on performance thresholds.

Interactive Quiz• Knowledge Check

Question 1

What is the key functional difference between a Table visual and a Matrix visual in Power BI?

Question 2

Which conditional formatting feature embeds miniature horizontal bars inside table cells?

Question 3

How do you enable stepped layout formatting in a Matrix visual?

Question 4

Can a Matrix visual display subtotals for individual hierarchy levels?

Question 5

How can you sort a Matrix visual by a specific measure (e.g. Total Revenue descending)?

Next Lesson

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Previous Lesson	Next Lesson
Bar, Line, and Pie Charts	Cards and KPIs

Test your understanding of this lesson with 5 questions. Each question has one correct answer.