Forum Discussion

Narendra's avatar
Narendra
Microsoft Employee
10 years ago
Solved

How to remove the Brackets for negative values in Power Bi Desktop

Hi All, How to remove the Brackets for negative values in Power Bi Desktop. In my source i have value like -$8,516,634.3 but in my power bi report it is showing like  ($8,516,634.3). Will you please...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    Narendra

     

    It seems some standard accounting way to show negative numbers in parentheses. If you don't like it, based on my test, you can set the format as "$ Afrikaans(Namibia)" which has the same US dollar sign and indicates negative with a "-".

     

    You can custom a decimal number in more ways by using FORMAT.

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Narendra On modelling tab under Data Type change Format to decimal number. This will also take currency symbol away.

  • Narendra's avatar
    Narendra
    Microsoft Employee
    10 years ago

    Hi Ankit,

     

    Already my data type is decimal number only. Actually my question is i want to show the negative values instead of brackets. Can we do the custom format cells for columns like excel...

    • jbaynham's avatar
      jbaynham
      Regular Visitor
      10 years ago

      There are 2 dropdowns there, one for data type and one for data format.  Ankit is saying change the format to Decimal Number (it probably says General currently).