ADVANCED Matrix Formatting I ALTERNATE Column or Row COLOR in Power BI

In this video I show you how to improve the design of a table or matrix visual with a little bit of DAX. You will learn step by step how to take your table to the next level and alternate the background color by column or row. Advanced table formatting.... here we go!
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:32 Standard Color Banding
01:39 Color Banding with DAX – Intro Example
05:11 Using MOD() for conditional formatting
06:41 Using RANKX for color banding
12:38 Color banding with multiple levels
16:03 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[Borka-etwe]

Great video! But if I want to format the whole row (including the header to the very left)? I have a P&L with only one measure in the values. It is both account groups sums, gross margin, gross margin%, EBIT and EBIt%. But all in one measure thanks to a switch formula. But now I want to differentiate these different rows.

[harshbadgujar]

Hey, i love your work. I had just one query, can you please share how you made this matrix that you show in video at 1:04 timestamp. It would be great to see step by step tutorial for that

[xxx-hxyp]

Thank you for this great video, please how did you get months/year on columns knowing that generally dates are stored in one single column ?

[ongz]

Awesome! Anyone know how to format the rows in a matrix individually?

[mindortv]

Very good video But I have a question. What if I have some blank spaces in that matrix? How can I give them bg color as well?

[dantepraxedis]

Good video, you are improving Power BI where it needed most: Lok and feel. I think Power BI should have this features out of the box.

[susanclark]

This is a great idea - but I think since I have my columns as rows - I can only seem to get this to highlight rows and not columns. So close! Thanks for all you do!

[kuldippandey]

this was great, Bas! : I want something related to Conditional formatting on a Matrix, but it should be individually applied to each subtotals sections. i.e. in this video for "Cost of Good Sold" (Top, Middle, Bottom) and for "Operating Expenses" (Top, Middle, Bottom) it should work separately.
Could you please help

[PeterKontogeorgis]

Great content as always Bas! Would love to see a video where you show some tips on how to create a pretty table/matrix.

[sysieWoo]

Hi Bas, thanks for putting together this video. That is a very useful tip. One question -
How do you work out the ranked value of the column if some of the rows have a blank value? Also, if there is no product dimension table and only has on single Sales fact table in the data model?

[BeHappii]

I have an inquiry regarding setting up a logic in Power BI that allows users to select colours based on Excel input data, affecting the colour of column headers in a dynamic fashion. The idea is for the system to recognise numerical inputs - with '1' representing green, '2' signifying blue, and '3' indicating red - and to modify the column header colour accordingly. The dataset is updated on a monthly basis, which calls for a logic where changes made in Excel are seamlessly integrated and mirrored in Power BI. My focus is solely on columns, as my column tables don't include rows. Despite the unique nature of this user requirement, which has kept me puzzled for nearly a week, I'm reaching out to see if you could provide guidance or perhaps produce a video tutorial on this topic.

[magnusvangekjrchristensen]

Hi Bas, Great video! I have a problem with conditionally coloring cells with blank values. Cells with value work fine, but not blank ones. Hot can I solve this? Thank you!

[danimr]

Nice one thanks for sharing...the table you have shown if we have different condition for each column in matrix how do we apply conditional formatting on that.

[PavanCh-qu]

Hi, Great to see your videos and lot of cool and great stuff..
I am exploring one option, but I am unable to find the solution. What I am looking for is I like to add icon like emoji or something (same for all rows) before +/- field of the rows so my row field order will be emoji field (emoji will be repeated for all the rows and) and then my main category fields which will have expand or collapse icons (+/-). Please suggest.

[sudhirsimson]

Nice video. Thank you. I want to ask for another possibility. I use a "Text filter" custom visual to filter a column and show the info in a table. How can I format the text in the table with a specific font colour (say blue) only for the Keywords used to search? I tried using CONTAINSTRING but cannot pass the "Find Text" parameter from the User Input text visual—any suggestions? The purpose is for the user to see the text they have searched easily. In some cases, it would filter multiple columns, so it would be easier if we have specific font colour or at least the background colour highlighted.

[ahmedabbas-mkwb]

I would like to know if it's possible to add background for each value individually in the column in 7 minutes and 45 seconds. Can you provide a solution?

[mathew]

Hi Bas nice video and approach to the solution - Question if I may is there a way to do a Top/Bottom N - that dynamically has the total of the remainder?

[phillipemenchaca]

Question - This is a great video that has helped me on multiple reports over the last few months, but how can I remove or use alternate color on the total column. I notice it is usually labeled as a "1" and if the total columns are odd, it then colors the last and the total. If i switch to ISEVEN, then the last two are left with the same color as well. Much appreciated!

[suzannenierop]

Hello Bas, do you also have an explanation how to change the background color if you have switched the values to the rows? But still want the date (columns) to be colored?
Thank you!

[sunilsasidharan]

Hi, could you please do a video where you can create several rows to a matrix. I have a requirement where I have to create different columns for different variables, example, No. of projects, Project phases, Project total Sales, Project incremental sales. When I tried, adding these to Rows, not all values are reflecting in the Matrix Visual.