Forum Discussion
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 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?
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 MatrixMarcoDid I answer your question? Mark my post as a solution! Appreciate your Kudos !!
4 Replies
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 MatrixMarcoDid I answer your question? Mark my post as a solution! Appreciate your Kudos !!
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?
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