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: [ Ссылка ]
SUBSCRIBE to learn more about Power and Excel BI!
[ Ссылка ]
Our PLAYLISTS:
- Join our DAX Fridays! Series: [ Ссылка ]
- Power BI dashboards for beginners: [ Ссылка ]
- Power BI Tips & Tricks: [ Ссылка ]
- Power Bi and Google Analytics: [ Ссылка ]
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
[ Ссылка ]
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: [ Ссылка ]
Contact us: [ Ссылка ]
▼▼▼▼▼▼▼▼▼▼
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:
[ Ссылка ]
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!
[ Ссылка ]
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► [ Ссылка ]
Twitter ► @curbalen, @ruthpozuelo
Facebook ► [ Ссылка ]
#CURBAL #SUBSCRIBE
