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!
Recommended Reading…
Power Query Foundations
Beginners Guide to Power Query
List Functions (200+ Examples)
Text Functions (150+ Examples)
Creating Tables (40+ Examples)
Generate the Ultimate Date Table
Advanced Topics
Master List.Generate with Easy Examples
Deep Dive into List.Accumulate
What’s up, just wanted to tell you, I liked this post.
It was practical. Keep on posting!
Thanks a ton for this.
I’ve been searching forever how to do this! This is great, thank you so much!
With the latest version of PowerBI, you can just update the field format similar to Excel to get this function!
#,##0_);(#,##0);”-“_);_(@_)
That was so easy! I’ve been searching for this and others have always brushed it off as it wasn’t possible. Thank you!
wow you are amazing!