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 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

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

5 Replies

  • 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