Format Measures Dialog Box
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
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.