Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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 mak...
Need Help
  • menglaro78's avatar
    menglaro78
    3 years ago

    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 !!

menglaro78's avatar
menglaro78
Microsoft Employee
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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).