Hi Mynda,
Can you please let me know how to format Red and Bracket for negative numbers.
I have used the attached formula and I can only get up to bracket for negative number. But I want them red too just like excel.
I did [Red] in front of the format and it is not working.
Please let me know the DAX formula for that.
Thank you so much.
Regards,
Aye
Hi Aye,
You need to use conditional formatting to apply red fonts for negative values.
Mynda
Hi Mynda,
Do I need to use rules?
I tried adding as attached and it does not make sense.
I do not have if value is less than "0" to start with.
please let me know. thank you.
PS. I am sorry I have to copied on word because I want to show drop down list, which I cant do that on screen cut.
Regards,
Aye
Yes, you add rules. Start with the negative values: if value is greater than or equal to, -99999999, Number and less than 0, number is red. Then add a rule for the positive values; if value is greater than or equal to 0, number and is less than 9999999, number, is black.
Many thanks, Mynda.
Regards,
Aye
