Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Natalet
Regular Visitor

Currency format for negative numbers in Tabular cube

Hi, All!

I want to format numbers as a currency (always with $ at the beginning). I tryied to use standard format for currency for my calculated measure, because I always use it and it works fine for Revenue measure, i.e. in Excel it shows $213 for value 213. But the problem in my case is that I have a measure "Profit" and it could be negative and I don't want to format negative currency value in brackets (as it format default in tabular cube for currency format), i.e. $-213 it shows in Excel as $(213).

I tried to use custom format: $##,###.##;$-##,###.## instead, but in Excel it shows rubbles (Russian currency). I don't need rubbles, I want dollars! How can I fix it?

Here is an example how it shows my custom format in Excel:

Natalet_0-1625654081488.png

 

2 ACCEPTED SOLUTIONS
Fowmy
Super User
Super User

@Natalet 

Under Modeling Tab choose Custom Format and apply the below format

$#0.00;$-#0.00;$#0.00

Fowmy_0-1625655259485.png

Fowmy_1-1625655291445.png

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

@Natalet 

It works for me, both in Excel and Power BI, my currency setting is below. Please change and check if it's differs.

Fowmy_0-1625656355495.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

7 REPLIES 7
Fowmy
Super User
Super User

@Natalet 

Under Modeling Tab choose Custom Format and apply the below format

$#0.00;$-#0.00;$#0.00

Fowmy_0-1625655259485.png

Fowmy_1-1625655291445.png

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Great...!, Thanks, It's working for me.
I want to know the logic behind this code $#0.00;$-#0.00;$#0.00
Positive;Negative;?

Thanks for advise! But again I received in Excel rubbles (it's because of loacle I guess and I need dollars)

Here is a screen what I get when use currency English format in cube (first column) and when I use your format string (second column)

Natalet_0-1625655619161.png

 

 

@Natalet 

It works for me, both in Excel and Power BI, my currency setting is below. Please change and check if it's differs.

Fowmy_0-1625656355495.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thanks! 

Anonymous
Not applicable

@Natalet that solution should work, kindly try again.

Thanks! Defenetly it's because of locale( some o our users would have to switch locale, I didn't find another decision through DAX

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.