Format Measures Dialog Box
The Format Measures dialog box is used to change the visual representation of data that is based on a measure calculation.
To access this dialog, open the PowerPivot window, then right-click a measure in the Calculation Area and select Format. You can also select a measure and then choose More Formats in the Formatting list of the Home page.
Formatting can only be specified for standalone measures that you created explicitly, by either typing a formula in a cell of the Calculation Area or by clicking New Measure in the PowerPivot ribbon. If you created an implicit measure by dragging a field to the Values area of the Field List, formatting is fixed and cannot be modified using the Format Measures dialog.