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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pavel
New Member

Formatting measure values as currency

Hi,

 

I have a column in my dataset which is formatted as currency, and contains sales values. I also have a measure which calculates a running total for a given period using a dax function:

 

RunningNettoWeek = CALCULATE(SUM(Sales[NETTOPREMIE]);FILTER(ALL(Sales[Week]);Sales[Week] <= MAX(Sales[Week])))

 

The problem is that the values lose their formatting when processed through a measure. Is there any way for me to get that formatting back? I've tried wrapping my CALCULATE() function in FORMAT(), but that resulted in values not showing at all in my charts.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

In the data Modeling area, click on your measure and then click on the $ icon to format the measure as currency.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
gamos
Frequent Visitor

Select the Model tab in your Power BI project.
Choose the measure/field in your data source. Expand the Properties box if hidden.
Scroll down to Formatting in the Properties box. Here you can change the Data Type and Format. (If trying to make a number display as Currency, change format from General to Currency.)

Greg_Deckler
Super User
Super User

In the data Modeling area, click on your measure and then click on the $ icon to format the measure as currency.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Click on the the measure name in the FIELDS pane and then select the Modeling Tab. In the Formatting area click the drop down next to the $ and choose your selected currency. 

 

Smiley Happy

 

Hope this is of help.

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors