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

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

DHoban's avatar
DHoban
Regular Visitor
8 years ago

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