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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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