Forum Discussion

DSP's avatar
DSP
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's avatar
    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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

mark your measure or calculated column in the fields pane.

 

From the modeling menu you can change the format of your measure:

 

 

Hope this helps

 

Regards