Forum Discussion

Narendra's avatar
Narendra
Icon for Microsoft Employee rankMicrosoft 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
Icon for Community Champion rankCommunity 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
Icon for Microsoft Employee rankMicrosoft 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).