Good information, Thank u.. but still we can make it in simpler way without using dax function.. just paste that number format in the Format Tab of that column..it will convert it as text format.. To change the colour, in conditional format we can use "Is Start with" field and add value as "(" and change the colour to red

You can also use this in dynamic string format

Really helpfull . Keep it up

Hi, use it ABS

I don't understand one thing we u can do directly conditional formatting in Values why u have created column for Formatted values ?

Format Negative = FORMAT( SUM(Sheet1[Value]), "#; (#);")