Negative quantity less then ZERO in brackets

[BigTommy]

Hello my fello Power BI MASTERS!

How to format to have negarive quantity which are less than ZERO to show in brackets?

the FORMAT[measure], ##,###.###0;(##,###.###0) is working but cannot figure out how to display zero on front... see below:

-0.2964 giving me  (,2964) but I want (0.2964)

-0.2599 giving me (,2599) but I want (0.2599)

for quantity like below I have correct format but instead of "." after 5 I have ","

-5.2300 = (5,300)

Please send help!

Big Tommy

[Pragati11 · Accepted solution]

Hi @BigTommy ,

I created a test column with negative values in it and have formatted them as shown below:

The column I created for formatting the negative values is as follows:

NegFormat = FORMAT(Negative[values], "##,###.###0;(##,###0.###0)")

Use your column name in above dax expression.

Let me know if this is what you are looking for.

Thanks,

Pragati

[amitchandak]

@BigTommy , refer

https://www.youtube.com/watch?v=dNLuTqg938A

[Pragati11 · Accepted solution]

Hi @BigTommy ,

I created a test column with negative values in it and have formatted them as shown below:

The column I created for formatting the negative values is as follows:

NegFormat = FORMAT(Negative[values], "##,###.###0;(##,###0.###0)")

Use your column name in above dax expression.

Let me know if this is what you are looking for.

Thanks,

Pragati

[BigTommy]

hey, thank you for your help. 

So I have entered this and yes, is ok however, I have still "," instead of "."

-5.23 is now (5,23)

Also I have forgfot to mention this is currencly so when I do this I am missing the EUR sign.

is there any way to show this as currency? Euro? 

[Pragati11 · Accepted solution]

Hi @BigTommy ,

Modify the dax as shown in the below screenshot:

I have tried this on POUND currency, you can do similar for EUR currency.

 Regarding your , and . issue, check your regional settings as shown below:

The higlighted decimal symbol at my end is "."

At your end I think it is ",", therefore you are seeing the difference. Modifying this should resolve your issue.

THanks,

Pragati

[BigTommy]

Thank you for your help!

Have a great week!