How to Display Negative Numbers Between Parentheses in Power BI

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:

Format negative numbers between parentheses

Until next time!

About Rick de Groot

Rick is the founder and editor of BI Gorilla. He believes learning is one of the great pleasures in life and wants to share his knowledge to help you improve your skills.

Learn more about him here, connect with him on Twitter, Facebook and LinkedIn and subscribe to his YouTube Channel.

4 thoughts on “How to Display Negative Numbers Between Parentheses in Power BI”

  1. With the latest version of PowerBI, you can just update the field format similar to Excel to get this function!



Leave a comment