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.