New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

20 tricks to finally master the Matrix visualization in Power BI

The matrix visualization has over 100 configuration options, and some of the most basic functionality, like hiding subtotals is not so easy to discover. In today’s video, I will show you 20 things you can do on the matrix that will take that visualization to the next level.

Table of contents:

Style Options:
00:00 20 Matrix secrets in Power BI
01:00 Quickly change the look and feel on the matrix
01:40 Quickly change text size
02:30 Collapse menu items
02:50 Center values, headers, etc..

Column Headers:
04:09 Disable auto-sizing on columns Row Headers:
04:30 Add +/- on rows
05:13 Show rows as columns (stepped layout)

Values:
06:19 Show values on rows 06:50 Banded row style

Subtotals/Grand totals:
07:50 Get rid of subtotals, but keep grand totals
08:10 Show only Grand totals
08:50 Show only Subtotals
09:11 Change the grand/sub total label
09:20 Change position of subtotals and grand totals

Field formatting:
09:50 Change field formatting
10:20 Apply field formatting, and alignment to grand totals
10:50 Apply field formatting, and alignment to headers

Conditional formatting:
11:09 Conditional format columns
11:23 Add KPI icons to matrix

Watch the tutorial:

20 tricks to finally master the Matrix visualization in Power BI!!
Was this helpful?
Previous Add colored KPI icons to a Power BI matrix
Next Make your tables look AMAZINGLY beautiful with these two tricks in Power BI

Reader Interactions

Let us know your thoughts...

Table of Contents