Forum Discussion

Frequent Visitor

9 years ago

Solved

Measures - editing number formats

Very new to PBI - I've downloaded the latest version. I've imported an Excel workbook with Powerpivot model into PBI, set up a matrix, and added a couple of fields and a Total Sales Amount measur...

Anonymous
9 years ago
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

Anonymous

Not applicable

9 years ago

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