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.
     
     

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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.
 
 

 

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

Nice, but would I need to write that for every measure I want to colour.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Si_7777,

     

    Thanks for reaching out to the Microsoft Fabric Forum Community.

    And aslo Thanks to ryan_mayu  & BhavinVyas3003  for prompt and useful responce.


    Yes, if you want different measures to have dynamic colors based on their own values, you'd typically need a separate color measure for each because each measure has its own logic and values.

    If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

    Best regards,
    Prasanna Kumar