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.

Did I miss any? Let me know in the comments :)

Keynotes:
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 autosizing 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 aligment to grand totals
10:50 Apply field formatting, and aligment to headers

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

Column subtotals:

Here you can download all the pbix files: https://curbal.com/donwloadcenter

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/coursesoverview

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

https://curbal.com/product/sponsorme

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://www.amazon.com/shop/curbal

************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#CURBAL #SUBSCRIBE