Matrix visual: How to conditionally format the column header, Values font size, or Values border?

[Anonymous]

I have a matrix control with 12 columns, Jan thru Dec. I have several measures as rows. I would like to indicate the current month in some way such as making all the cells in that column bold, or making them all have a border, or by giving the column header for that month a different background colour.

This is what I have currently. The Values background colour is set using Conditional Formatting.

Assuming Sep is the current month, this is how I would like it to appear (a different cell border for that month):

or make the cells font for that month bold:

Does anyone have any suggestions on how to do this?

[menglaro78 · Accepted solution]

HI @Anonymous ,

I suggest to create a measure for Check current Month like this:

CheckMonth = IF(MONTH(TODAY()) = SELECTEDVALUE('Table'[Mese]), "Red", "Black")

Apply conditional formatting for value of Matrix

Marco

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Anonymous]

@menglaro78 , thanks for your suggestion. Changing the colour of the cell value font is the least favourable option. Is there any way to change the background colour of the column header, or to achieve the other two options I described in my port?

[menglaro78]

Hi,

in my opinion you can't get what you're asking for, because those options, such as border, don't have the Fx button, so they can't apply conditional formatting.

Marco

[Anonymous]

@menglaro78 , that's what I suspected. Thanks for confirming, and thanks for your suggestion, it seems to be the easiest way to achieve what I am trying to do (though not ideal).