#wipro

[@shashi9709]

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

[@vitthalchavan7578]

Really helpfull . Keep it up

[@sourabhpatel3834]

You can also use this in dynamic string format

[@sarihaddu]

Please tell how.

[@deepthireddybapatu1192]

Hi, use it ABS

[@abdulhussainpashuda7903]

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

[@sarihaddu]

Please give the formula.

[@bajigunturu910]

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