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

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