PowerPivot Format Percentage for DAX Measure

PowerPivot Format Percentage for DAX Measure

One of the most useful features of the new DAX measures in PowerPivot is the ability to specify a set format for the measure so that every time you use it in a pivot table it automatically formats to your requirements, instead of the usual issue of having to format a pivot table every time you introduce a new value.

Related: Learn how to use PowerPivot

Most of the formatting is fairly obvious but the one that is slightly hidden is the PowerPivot format percentage option.

In traditional Excel the percentage formatting is its own option. However, in PowerPivot it has been included in the Number category.

To get to it you need to click on the Number catergory and then click on the drop down to find the percentage option as shown below