Formatting

With ActiveUI you can apply a custom formatting to any measure:

All measures come with a default formatter defined in ActivePivot. To change the default formatting of a measure, check with your product development team.

Add Formatting

1. To access the formatting dialog box, right click a column header and select "Formatting."
2. Set the new default number format in the field "Format number as", for example, ###,###.0. Please refer to Format String MDX Cell Properties at Microsoft.com to read more about format syntax.
3. To edit the color, background color and font, click "Default style".
4. To add conditional formatting, click "Add a style rule".

You can also directly edit the MDX to implement any complex formatting logic. Read more about how to use the Mdx Editor.

A Measure with formatting can be saved as a Calculated Measure in the Data Explorer.

Understanding how formatting works

When custom formatting is applied, the MDX query behind the widget is modified to include properties such as FORMAT_STRING, BACK_COLOR, and more. For example:

Note the "CELL PROPERTIES" keyword that enables visualization of the listed properties in a widget.