Formatting is key in financial reporting. It helps users consume the data in a pleasing way. One aspect that is often looked at in Balance sheets and Profit and Loss statements is the notation of negative numbers. Readers want an easy way to differentiate positive numbers from negative numbers. In Power BI, by default negative values have a minus sign before the number. The standard accounting way however is to have negative numbers between parentheses and optionally marked red. The following video shows how to display negative values between brackets in Power BI.
As you can see users can get very creative with their custom formatting. Numbers can be shown in thousands, with parentheses or dash before a number, currency symbols or decimal numbers. Change it to your liking. A little reminder for those seeking some formatting options:
Until next time!