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.

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 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 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/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

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/courses-overview

☼☼☼☼☼☼☼☼☼☼

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/sponsor-me

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

Видео 20 tricks to finally master the Matrix visualization in Power BI!! канала Curbal