How to Format Currency number in Red when Negative

[Anonymous]

Hi,

Would you please help me to Format Currency number in Red when Negative. What should I add to the below

FORMAT([Measure]*VALUES(Currencies[Currency Rate]), "€ #,#"

Thanks in advance

lamia

[PaulDBrown]

@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]

[Anonymous]

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]

@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]

Did not managed to have it in red with my measure - Also my reports contains many measures where numbers are negative - I would have liked to have the how to get red numbers using FORMAT fuction

Someting like below, but I d'ont know how to right it to obtain the desired result

[PaulDBrown]

@Anonymous 
FORMAT does not currently allow colour coding.

So how are the negative values represented in your measures? 
can you post a table with negative values?

[Anonymous]

You are right, we can see that nothing is happening as Format does not handle color formatting

[PaulDBrown]

@Anonymous 

Sorry, I'm answering from my phone, so I can't read the name of the measure you have posted to show that FORMAT doesn't colour code. 
but basically you need, as per my example above:

let's call this last measure [your measure]
to identify negative values for this measure you need:

Condit Format for your measure =IF(CONTAINSTRING([your measure], "-"), 1)

now follow the instructions in the post with the method I posted above.

[Anonymous]

I believe that would be the only solution for me to color formatting my negative numbers - I will give a try and let you know 

Many thanks for your valuable help

[PaulDBrown]

@Anonymous 

Just to be clear, you don't need to create a conditional formatting measure for  all your currency measures; only the measure your will be using in the visual. 

[Tahreem24]

@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]

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

[Anonymous]

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]

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

[Portrek]

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]

Thanks - but still this is not really helping in my case