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: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: 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:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: 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:
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!
www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Пікірлер: 340
"Show columns on rows" was a big time life saviour for me! Thanks a ton Ruth! 🔥
@CurbalEN
3 жыл бұрын
Yey!! /Ruth
@abhijeetghosh27
3 жыл бұрын
@@CurbalEN Really Ruth... It was a big time life saviour..thanks for these wonderful videos 😃😃
@CurbalEN
3 жыл бұрын
Yey!! 🥳🥳
@MoodyVideoGraphies
3 жыл бұрын
Yes true... Thanks a ton.
Ruth, there are a lot of great tips here but one of the simplest is also a real time-saver: searching for all text and alignment fields at once. Many thanks for sharing your advice across so many excellent videos.
@CurbalEN
2 жыл бұрын
And thanks for your feedback !
Thank you so much! Keep sharing making segments and spreading the love
@CurbalEN
3 жыл бұрын
Will do!!
Hi Ruth, Thank you so much for your video. I have been looking for the function of showing values as rows for several days. Your video saved me a lot of time!!!
@CurbalEN
Жыл бұрын
Music to my ears!!
Great summary. I didn't you could enter text and find all the options containing that text. A big time saver! Thanks toda muchas gracias, tack!
@CurbalEN
4 жыл бұрын
Yes, and you can do that with any visual property!!
I always appreciate your helpful tips, Ruth! You are legendary 😊
@CurbalEN
4 жыл бұрын
😊😊
Thanks Ruth, This escaping me from messing up with the matrix.
Is the first time that I watch one of your videos, thank you for all the passion that you transmit while you're explaining. Greetings from Ecuador!
@CurbalEN
3 жыл бұрын
And thanks to you for the feedback!
Applied some of these tips in my matrix report. Thanks Ruth
Some great content here Ruth! Thank you!
Gracias "Curbal" eres una tigresa en el los tips de Power BI....Good luck and happy day!!!
Thanks so much for sharing these! :)
I love your changing text size trick!! Thank you for the awesome tutorial =)
Brilliant summary and a great go-to resource....thanks very much Ruth. Keep well.
@CurbalEN
4 жыл бұрын
You too Dave and thanks :) /Ruth
Thank you Thank you Thank you!! I cannot tell you how many questions this solved for me!!
Thank you very much!!! This video helped me a lot.
Many Thanks. Super useful
Really wanted to say that your videos are really entertaining while also being informative. I come home from work working with Power BI all day (I am blessed, this is almost a hobby) and to relax I put on some of your videos :) definitely makes it easier to learn - and everything is told in plain English that is easily understandable. In return I try to support with a comment and a like wherever I can! :)
@CurbalEN
4 жыл бұрын
An honor to be your wing (wo)man ;) And thanks for the support, it does make a difference!
@happyheart9431
Жыл бұрын
100 % agree with your words..Million Thanks Curbal
Hey Ruth , love this. Just this week I developed a report using a Matrix and some clever tooltips to display covid patients /wards they are on and then on tooltip display all patients who shared a space with them on each date as they go from positive/negative etc. It looks amazing and really shocked me how much you can squeeze out of BI and matrixs in particular.
@CurbalEN
4 жыл бұрын
Sounds really cool, well done!! 👏👏
Thanks for the video. Very helpful indeed
It's really really helpful, thank you so much 😊
Nr 8 was new for me. Keep up these good vids, you have a great way of communicating this stuff :-).
@CurbalEN
4 жыл бұрын
Thanks! /Ruth
Appreciate your tutorials. Keep up the good work!
@CurbalEN
4 жыл бұрын
Will do! :) /Ruth
the best i was looking like anything best in the business thanks
Thanks for sharing the knowledge... Really gud one 😊
@CurbalEN
4 жыл бұрын
The matrix has like 1M settings so I hope this takes us one step forward! /Ruth
You saved my day! ... Again :-)
Thank you so much!!
Thank you so much very informative
Dear Ruth, Thanks a million for your brilliant tutorials!!! Number 8 (show column as row) was new for me👌
@CurbalEN
4 жыл бұрын
🥳🥳🥳
@mischapeters5204
3 жыл бұрын
@@CurbalEN I can't find the show on rows option in the value pane, it seems that is no longer available anymore, am I correct?
Many thanks for the tip 7 and 8 and great content.
@CurbalEN
3 жыл бұрын
Fab!!
Thank you. i enjoyed the video. You explain everything so well. :)
@CurbalEN
3 жыл бұрын
Thanks Nel!
Thank you very much. Very useful.
Great tips! Helps save a lot of time. Thanks!
@CurbalEN
4 жыл бұрын
My pleasure!! /Ruth
You are so super funny while explaining stuff. Awesome
Thanks to share such tips. Nice options. Really good video.
@CurbalEN
4 жыл бұрын
Thanks!!
Thank you😊
All very interesting! Thanks for sharing! 👏👏👏
@CurbalEN
4 жыл бұрын
Yey!! 🥳🥳
Great video!!!
Thanks so much. Very useful. Much appreciated
@CurbalEN
4 жыл бұрын
My pleasure!!
Very nice and veeeeery useful tips…. Thanks for sharing this video
@CurbalEN
2 жыл бұрын
Thank you for watching!!
Excellent tutorial Curbal. Super explanation!!!
@CurbalEN
3 жыл бұрын
Yey 🥳🥳
Great video.. Thanks for sharing nice video
Great tips, most I will be using. Thanks
@CurbalEN
4 жыл бұрын
Yey!! 😊😊
Gracias Ruth excelentes tips para formatear matrices. Buen fin de semana.
@CurbalEN
4 жыл бұрын
Igualmente :)
Big Thank You Ruth :) you have cleared all my confusion related to Matrix Visual specially +/- & Step Layout. I have one question on matrix ,can we achieve slicer to highlight values instead of filter in matrix.
Great video! really useful!
@CurbalEN
2 жыл бұрын
Fab!
Thanks a lot for sharing, Great video.
@CurbalEN
4 жыл бұрын
Thanks 😊
awesome thanks
Gracias Ruth , muy productivo como siempre .
@CurbalEN
4 жыл бұрын
Perfecto! :)
This one video is probably the most useful thing i've seen in powerbi
@CurbalEN
2 жыл бұрын
Wonderful to hear!
Million thanks
wonderful ......thanks a lot
@aas2943
3 жыл бұрын
ur great
thank you so much! very helpful!
@CurbalEN
4 жыл бұрын
Yey!! 😊
6:51 Show in columns has been save my life several times. On my experience, Excel Finance user and some Sales People love to have table in that way. It works / looks fine if you have few categories-few rows, so if give you a quick overview about how the month is going on and adding a KPI/conditional formatting provides a quick look of it's red or green. It is more like a manual table created on a spreadsheet where each value is in cell (C2) and below the other one (C3) and so on. Sometimes I used to save space on the canvas. Having columns "unpivoted" give more space to the right save of the visualization
@CurbalEN
4 жыл бұрын
Thanks for sharing !!
@yannickfranckum6589
4 жыл бұрын
I had the same experience working for a customer. Measures on rows, and actual, goal, prior year, changes,... values on columns. To finally have like a KPI matrix and being able to have an overview.
Another perfect video .. Thanks!
@CurbalEN
3 жыл бұрын
Yey!! 🥳🥳
thanks very much Ruth, you are my inspiration
@CurbalEN
3 жыл бұрын
Thanks!
Your genius...Million million thanks..
Gcs Ruth, Show columns on Row, lo había usado y no me acordaba donde estaba, te ganaste un like.
@CurbalEN
3 жыл бұрын
Y tu también ;)
The show only grand total trick is awesome too!
You saved my life ( once again)!
@CurbalEN
Жыл бұрын
At your service !!
I have referenced this SO MANY times - a lot of it for the same thing over & over because for some reason I just cannot remember how to do the "step out"! Thanks so much :)
@CurbalEN
Жыл бұрын
I do the same 😂
Thanks so much. Very helpful...
@CurbalEN
4 жыл бұрын
Yey!! 🥳🥳
I just had to sign into my KZread account and like this video because this video has really helped me out!
@CurbalEN
2 жыл бұрын
Thanks for the feedback :)
Thank u so much...
Many Thanks , I like your video so much.
@CurbalEN
Жыл бұрын
Thanks!
Pls honey am in love with all the tutorials. More GRACE.
It’s a great video - many thanks. Is there a way to align totals in the centre as well? It looks a bit wired to have all values aligned in the centre but not totals. Thanks again
Thanks Ruth! I really like it! Gracias campeona mundial!
@CurbalEN
4 жыл бұрын
Yey!!
Thanks!!!
@CurbalEN
2 жыл бұрын
Yey!!
Thanks so much I didn't know about the show rows as columns options shaved 2 to 3 seconds in load time because of combining vizs
@CurbalEN
Жыл бұрын
Priceless!
Muchísimas gracias, no tienes idea de cómo me has ayudado a entender ésto
That "show on rows" piece just saved me a whole lot of work! Thank you!
I got solution with help of this video, thanks lots
Is there a way to torn off the sorting option on the column? i have tried this but it just wont go away. i need to load my row values in a certain order but it keeps sorting it. is there any way around this? i m missing ssrs so much after this problem. 😊
Hey Ruth , thank you !! I was wondering if there could be an option to conditionally format a calc group column with dual Headers ?? like year followed by category in columns .. Year and its calculation are from Calc Group..
Thanks for your video. Is there any way to show group headers, then a specific measure for those groups and add then a further group and measures? I can do this in reporting services, but I am not able to find a way in Power BI.
Thanks for the video. Is it possible to change the subtotal labels as dynamic. Currently there is no option to change subtotal labels to dynamic based on the values?
Hi Ruth, It's really appreciate of sharing knowledge on matrix , it's really complex. I have to cross a scenario like we have -/+ icon enable for row wise right, is there a way to have in column like you shown three columns right in that we will show only percentage by expanding we need to see the sales and one more column value you shown in video?
Dear Ruth, there are two things that are still bothering me in a matrix, maybe you have a solution for it as well: 1. is there a way to sort the columns headers (e.g. from left to right) based on the column totals (not column names)? 2. if in a martix in the column area you have e.g. years (2017, 2018, 2019) and value sales and unit sales, the first layer of the column headers is a year and then all values below. Is it possible to reverse it (like in pivot tables in Excel) that first you have e.g. value sales (and years below) and unit sales (and years below)? I can't seem to find that option. I would really appreciate some tips on it. Many thanks in advance! :-)
Thanks Ruth! A very informative video. One issue I am grappling with is that the grand totals are not always the sum of the measures displayed in the columns. Like for instance we have a matrix for surveys. We should the participant count against the category (Say location wise) as count distinct of employee no. When the measure value is count distinct the grand total is not displayed correct. Is there any way to fix this?
Thank you, these tips are very useful. Is there any way to add a custom row into the matrix?
Thank You Ruth for the very usefull content ,my question is can we move quick measure column from values to the rows in matrix
@CurbalEN
2 жыл бұрын
You should, but I have never tried
Hello Ruth, As always very informative video. Thanks a lot. Is it possible to have row subtotal as average and column subtotal still be a total or sum?
@aniketkulkarni684
2 жыл бұрын
I know this is a old video and I was going through it again to see whether it covers what I am looking for.
Thanks Ruth for sharing your knowledge !! Is it possible in the same matrix have the grand total for considering the filtered rows AND the grand total without considering the filtered rows like the option in excel classical pivot? Thank you in advance!!!
Thanks Ruth. Do you know if there is a way of conditionally formatting row headers in a Matrix? I have a matrix with sales per employee and need to conditionally highlight (change background color ) for an entire row (row header and values) for new employees. I can do that in the values but I don't know how to do it in the row headers so that the entire line has the same background color
Thank you for tips, Is there anyway I can show the Matrices without scroll bar, just break the table and show side by side?
Hello there Ruth. Kudos for the presentation! Do you know by any chance when the custom column sort will be available for the matrix visualisation? It is available for the table visualisation and it would be great to have it for the matrix as well...
@CurbalEN
4 жыл бұрын
I am afraid I dont know , hopefully soon!! /Ruth
Thank you Curbal, I really thank for great content, your videos are helps a lot. May I know the approch how can we change the font to the specific column vales in matrix.thanks
5:58 Cool! Didn't know about it!
@CurbalEN
4 жыл бұрын
A lot of settings hidden in those toggles!! /Ruth
Hello Ruth, thank you for providing hi quality content, first of all! Really appreciate it and saved me several times. Regarding the matrix visual I have a question. If my columns are different months, for like a forecast over time or similar. Is it possible to make a setting as rotating colours. Meaning January white, February Black, March white, April black for easier readability? Searched quite a bit , couldn't find it. If you can make a video about this, greatly appreciated!
Totals and SubTotals... jajaja. Great trick in order to hide the subtotals only in rows!! 👌 Thanks a lot!!
@CurbalEN
3 жыл бұрын
You welcome!
You're the best
Thanks for the video, I have a question, what if I want to visualize all the columns always regardless of the filters or content... i.e. Sales for all months including when there were 0 on months.
Thanks Ruth. I am putting a date hierarchy in the columns and it returns 0 in unselected dates. The column header still appears for the dates u selected in the filter but with no values. How can I hide those date columns ?
best video ever
Thanks Ruth, very useful for me . I have a question... In a matrix, there are 5 rows like sales, sales visit, sales prospect, sales order... i want to collapse these 4 sales into 1sales row (only sales)? Plz help....
Thanks for sharing the wonderful tips. Stepped layout and formatting will give the professional touch to my monthly presentation.
Thanks a lot for sharing, great video. Is it possible to show a line graphs inside the matrix visual? Like showing the sales by month line for each product row ?
@CurbalEN
4 жыл бұрын
Yes if you use svg. Search for "trendlines matrix power bi" on google to find tutorials. /Ruth
Merci beaucoup
@CurbalEN
3 жыл бұрын
mon plaisir :)
Hi Ruth, Is there any way we could change Column order? Thanks for your tips.