Table Headers format

Hi  CMSINFO ,

 

As you refer you cannot setup conditional formatting to a column header however you can do two things:

• Apply the same format of the column values to the header
• Apply conditional formatting to the values and background of values

Based on this two things you can do a workaroud:

• Your columns on the matrix needs to be converted to measures:
  • In my case I have 3 categories A, B, C that I want to have different colours
  • Create the following measures:

CAT A = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "A")

CAT B = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "B")

CAT C = CALCULATE(SUM(Table1[Value]);Table1[Cat] = "C")

 

• Place the measures in the columns of your matrix or table
• Go to the options of the table/matrix Field Formatting
• Choose each one of the measures and make the backgroung and letter the colour you want
  • In my example A = Green, B = Yellow, C = Red and letter for all of the white
  • For each one click the option Apply to header:

 

• Now add for each measure add conditional formatting for background and colour
  • In my example for all of them you have black text and white background
    • Be sure to choose diverging and both color the same

As you can see you have headers with different colours and the values of the tables are the same.

 

You can also use the other conditional formatting options as color scale or field value just be sure to add one line for the "normal" values that are to be in black colour.

 

So although the Condittional formatting is not actually on the headers it looks like it is.

 

See attach PBIX file.

 

Regards,

MFelix