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 large positive number per measure is laborius.

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.

Easy Conditional Format | Microsoft Fabric Community

5 Replies

ryan_mayu
Super 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
  Advocate II
  1 year ago
  Nice, but would I need to write that for every measure I want to colour.
  - 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
BhavinVyas3003
Super 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
  Advocate II
  1 year ago
  The choices int he dialog box are not that simple

Forum Discussion

Easy Conditional Format

5 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Conditional Formatting

Condition formatting