Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
1 year ago

colour code Font/text in matrix

Hi All,

 

Kindly suggest - how to colour code text/ font +ve and -ve values in matrix below coulmn.

+ve above zero red, -ve below zero to be green

Thank you.

2 Replies

  • dharmendars007's avatar
    dharmendars007
    Memorable Member

    Hello Snagalapur , 

    Set Up Conditional Formatting Rules
    In the Conditional Formatting window:

    1. Choose Format by: "Rules".
    2. Apply to Values or Specific Columns: Select the column or measure.
    3. Rule Type:
      1. Greater than or equal to 0: Set font color to red.
      2. Less than 0: Set font color to green.
        Confirm and close the dialog.

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

  • Hi Snagalapur ,

    Right click on top of your measure in value fields on your matrix, select conditional formatting, font color and make your rules based on your measure value, and hit ok: