Forum Discussion

Si_7777's avatar
Si_7777
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Easy Conditional Format

Is there a simple way to turn minus numbers to red and positive to green.  The whole conditional format dialog per measure is so long winded and convoluted.  Having to setup a large minus number and ...
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    Si_7777 

    I think then you need to create a measure for color setting.

     

    measure color = SWITCH(TRUE(),[Measure]>0,"#008000",[Measure]<0,"#FF0000")
     
    then choose field value and select the measure for color setting.
     
     

     

BhavinVyas3003's avatar
BhavinVyas3003
Icon for Super User rankSuper User
1 year ago

 

 

  • Select your Table/Matrix visual.
  • Click on the measure → Conditional formatting → Font color.
  • Choose Format by: Rules
    Based on: Same measure
    Add two rules:
    • If value < 0 → Red #FF0000
    • If value >= 0 → Green #00A000
  • Click OK.

 

Si_7777's avatar
Si_7777
Icon for Advocate II rankAdvocate II
1 year ago

The choices int he dialog box are not that simple