Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix/Table formatting - BOLD row

Hi,   Need help in  formatting one row to be bold in the Matrix. I ca use a table too...   Items Value A 10 B 20 C 30 D 10 E 10 Total 80   Thanks
  • rajendraongole1's avatar
    6 years ago

    Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.

     

    For example if i had this table:

     

    ExampleV 1V 2
    A15
    B26
    C37
    D48

     

    suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:

     

    Measure = IF(Table[Example] = "D", 1, 0)

     

    I can then apply the conditional formatting for each column using the rule and value =1

     

    In conditional format use the rule and call that measure.

     

    Regards,

    Rajendra

  • Anonymous's avatar
    Anonymous
    6 years ago

    I used Calculated column instead of measure and it worked.

    Thanks for your help