Hi,Would you please help me to Format Currency number in Red when Negative. What should I add to the belowFORMAT([Measure]*VALUES(Currencies[Currency Rate]), "€ #,#"Thanks in advancelamia

You can do that through conditional formating. look this video below, maybe this help you https://www.youtube.com/watch?v=lhf2tJeiwYw&feature=emb_logo Best regards.

Hi Anonymous You need to use the table chart type not Matrix and uder the conditional formatting select font color This will pop up a window and in the window choose as per below to get the desired result

Anonymous use the below article to set the red format when negative. https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-blog-conditionally-formatting-negative-numbers#:~:text=To%20change%20it%2C%20we%20click,to%20change%20it%20to%20Rules.

Thanks but this article is not helping as I need to use FORMAT fuction because I have a currency formated values

Thanks but I need to use FORMAT function because I have a currency formated values

How to Format Currency number in Red when Negative

16 Replies

Portrek
Resolver III
5 years ago
You can do that through conditional formating.

look this video below, maybe this help you

https://www.youtube.com/watch?v=lhf2tJeiwYw&feature=emb_logo

Best regards.
- Anonymous
  Not applicable
  5 years ago
  Thanks - but still this is not really helping in my case
Anonymous
Not applicable
5 years ago
Hi Anonymous

You need to use the table chart type not Matrix and uder the conditional formatting select font color

This will pop up a window and in the window choose as per below

to get the desired result
- Anonymous
  Not applicable
  5 years ago
  Thanks but I need to use FORMAT function because I have a currency formated values
Tahreem24
Super User
5 years ago
Anonymous use the below article to set the red format when negative.

https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-blog-conditionally-formatting-negative-numbers#:~:text=To%20change%20it%2C%20we%20click,to%20change%20it%20to%20Rules.
- Anonymous
  Not applicable
  5 years ago
  Thanks but this article is not helping as I need to use FORMAT fuction because I have a currency formated values
PaulDBrown
Community Champion
5 years ago
Anonymous

Why are you using the FORMAT function to convert it to currency (FORMAT converts it to type text)?

You can simply format the measure as currency using the type options for columns in the ribbon:

This way it remains a number and you can use conditional formatting as many have already suggested.
- Anonymous
  Not applicable
  5 years ago
  Because I have differents Currencies - I have a slicer where I can select local currency/USD/EUR - I need the FORMAT fuction to display the currency symbol when the corresponding currecy is selected on the slicer. Every thing is working find except that I can not color the numbers when negative
  - PaulDBrown
    Community Champion
    5 years ago
    Anonymous
    
    Ok, a very good reason then!
    
    Create a measure along the lines of:
    
    Conditional format negative values = IF(CONTAINSSTRING([Currency], "-"), 1)
    
    (assuming your negative values contain a "-" sign)
    
    Now go into the Formatting pane, select the measure under Conditional Formatting, activate "font color":
    
    Select rules from the dropdown and follow the setting in the image below:
    
    And you will get this:
- Anonymous
  Not applicable
  5 years ago