Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Would you please help me to Format Currency number in Red when Negative. What should I add to the below
Thanks in advance
lamia
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.
Proud to be a Super User!
Paul on Linkedin.
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
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:
Proud to be a Super User!
Paul on Linkedin.
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
@Lamia
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?
Proud to be a Super User!
Paul on Linkedin.
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.
Proud to be a Super User!
Paul on Linkedin.
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
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.
Proud to be a Super User!
Paul on Linkedin.
@Lamia use the below article to set the red format when negative.
Thanks but this article is not helping as I need to use FORMAT fuction because I have a currency formated values
Hi @Lamia
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
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Thanks but I need to use FORMAT function because I have a currency formated values
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.
Thanks - but still this is not really helping in my case
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |