negative value in bracket

[IF]

Hi,

I have a column that is called "project". its format is decimal number. I want to show negative values with brackets. I tried to make a measure (Measure=FORMAT([Project];"##,###;(##,###);-")

The PowerBI highlights under Project as if it doesn't recognize it. What should I do?

Best,

[Tahreem24 · Accepted solution]

@IF ,

What is [Project] exactly? Is it Measure or just a fields or Calculated column?

If it is field from table so try to use aggreagation like SUM,MAX etc.

[Anonymous]

@IF 

So you have to turn your column PROJECT into a measure. There are too many values, so you need to use MAX/MIN/SUM/etc. to tell the measure what specific value to turn into that format.

You will need two measures, for example:

Measure1 = MAX(Table[Project])

Measure2 = FORMAT( [Measure1], "###,###; (###,###); -")

(make sure to use more # if your numbers go into the millions i.e. "#,###,###; (#,###,###); -"

[IF]

Hi,

Thanks it works,  but the total gives wrong sum. How can I display correct sum?

Best regards,

[Tahreem24]

Refer the below video:

https://youtu.be/dNLuTqg938A

[Tahreem24]

Or you can also try using Dax:

= IF([Project]<0,&"("& [Project]&")", [Project])

[IF]

Hi,

When I type [Project], the power bi doesn't recognize it. it underlines it with red unfortunatelly.

[Tahreem24 · Accepted solution]

@IF ,

What is [Project] exactly? Is it Measure or just a fields or Calculated column?

If it is field from table so try to use aggreagation like SUM,MAX etc.

[Tahreem24 · Accepted solution]

@IF ,

Use the below DAX:

MEASURE = IF(SUM(Sheet6[Value])<0,"("& SUM(Sheet6[Value])&")", SUM(Sheet6[Value]))

[IF]

Hi,

Thank you very much for the help. it helps. The last issue if you could help: when I put brackets, I don't want to see the minus sign. it should be for example; -3 or (3) However, the sum should be as you showed. For example; (3)+4 sum:1 Is there any possibility not to show the minus value?

Regards,

IF