Forum Discussion

powerAveryBI's avatar
powerAveryBI
Frequent Visitor
2 years ago
Solved

Visual CARD RED on Negative Value.

Hi, I am seeking help on this:  How can I ensure that the font color is red if the "DELTA" field is NEGATIVE?      
  • Bipin-Lala's avatar
    2 years ago

    Hi powerAveryBI,

     

    To change the font color based on the value in the card, you would have to use "Conditional Formatting" available for Callout Value in the card.

    • Select the Card visual and open the Format Visual settings
    •  Navigate to Callout Value -> Color
    • Click on the Conditional Formatting Option

    • In the conditional formatting dialog box, select Format Style =  Rules. Subsequently, select the field (Delta value in your case) which will be used for setting up the color rules
    • Now set up the rules based on the values of the field i.e. if Delta < 0 then RED color, otherwise some other color etc. (Example is shown below)

     

    Voila! The card should now be displaying the value with the color as per the rules you set.

     

    Please refer to the following Microsoft Documentation for more details: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

     

    Do let me know if you face any issues!