- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Negative quantity less then ZERO in brackets
Hello my fello Power BI MASTERS!
How to format to have negarive quantity which are less than ZERO to show in brackets?
the FORMAT[measure], ##,###.###0;(##,###.###0) is working but cannot figure out how to display zero on front... see below:
-0.2964 giving me (,2964) but I want (0.2964)
-0.2599 giving me (,2599) but I want (0.2599)
for quantity like below I have correct format but instead of "." after 5 I have ","
-5.2300 = (5,300)
Please send help!
Big Tommy
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @BigTommy ,
I created a test column with negative values in it and have formatted them as shown below:
The column I created for formatting the negative values is as follows:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @BigTommy ,
Modify the dax as shown in the below screenshot:
I have tried this on POUND currency, you can do similar for EUR currency.
Regarding your , and . issue, check your regional settings as shown below:
The higlighted decimal symbol at my end is "."
At your end I think it is ",", therefore you are seeing the difference. Modifying this should resolve your issue.
THanks,
Pragati
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @BigTommy ,
I created a test column with negative values in it and have formatted them as shown below:
The column I created for formatting the negative values is as follows:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hey, thank you for your help.
So I have entered this and yes, is ok however, I have still "," instead of "."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @BigTommy ,
Modify the dax as shown in the below screenshot:
I have tried this on POUND currency, you can do similar for EUR currency.
Regarding your , and . issue, check your regional settings as shown below:
The higlighted decimal symbol at my end is "."
At your end I think it is ",", therefore you are seeing the difference. Modifying this should resolve your issue.
THanks,
Pragati
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you for your help!
Have a great week!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-22-2023 02:13 PM | |||
Anonymous
| 01-21-2020 08:20 AM | ||
Anonymous
| 03-23-2020 10:46 AM | ||
06-15-2024 07:37 AM | |||
Anonymous
| 12-02-2021 02:05 AM |
User | Count |
---|---|
83 | |
80 | |
46 | |
38 | |
37 |