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
Please tell how.
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
Really helpfull . Keep it up
I don't understand one thing we u can do directly conditional formatting in Values why u have created column for Formatted values ?
Please give the formula.
Format Negative = FORMAT( SUM(Sheet1[Value]), "#; (#);")
Hi, use it ABS