Forum Discussion
Measures - editing number formats
Hi,
If you use DAX to create a measure for the field you are using you can wrap that in the format function, e.g.
Measure = FORMAT( SUM( Table[Sales]), $#,##0;($#,##0) )The format function can take user defined formats as shown above (above is brackets for negative, comma separated dollar format.
For a bigger list of user defined function see here:https://msdn.microsoft.com/en-us/library/ee634206.aspx
Hope this helps,
Will
Within PowerBI, click on the measure and then go to Modeling on the menu. You'll see a Formatting section. Make changes there.
That's great - but what I had in mind is the custom formatting you have in Excel.
For example, to show numbers in round thousands: #,##0
You could always divide by 1,000 to get the same effect in this particular case - but what about putting negative numbers in brackets?
Hi,
If you use DAX to create a measure for the field you are using you can wrap that in the format function, e.g.
Measure = FORMAT( SUM( Table[Sales]), $#,##0;($#,##0) )The format function can take user defined formats as shown above (above is brackets for negative, comma separated dollar format.
For a bigger list of user defined function see here:https://msdn.microsoft.com/en-us/library/ee634206.aspx
Hope this helps,
Will
I am using Direct Query and I have already created a calculated field called Vendor Count (i.e. distinct Vendor count). I simply want to format the number "standard". 1) I don't see a drop down option that lets me do that 2) I also do not see where I can 'edit' the field to write the appropriate DAX syntax. Ideas? ~Denise
