Forum Discussion

BigTommy's avatar
BigTommy
Icon for Helper I rankHelper I
6 years ago
Solved

Negative quantity less then ZERO in brackets

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 fig...
Need Help
Show and Tell
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    6 years ago

    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

     

  • Pragati11's avatar
    Pragati11
    6 years ago

    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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

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's avatar
    BigTommy
    Icon for Helper I rankHelper I
    6 years ago

    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's avatar
      Pragati11
      Icon for Super User rankSuper User
      6 years ago

      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's avatar
        BigTommy
        Icon for Helper I rankHelper I
        6 years ago

        Thank you for your help!

         

        Have a great week!