Formatting Measure Type Column

Measure type column values can be formatted based on the following different options:

The measure formatting is displayed in the following screenshot and refer this section for formatting the widgets.

Window

Type

The measure column values display type can be defined through this based on the data displayed. For example, if you are displaying sales amount column, then type can be defined as Currency.

Type

Representation

The value display format representation can be defined through this. For example, through selecting Thousands, value 10,000 will be displayed as 10K.

Representation

Decimal Places

You can set the decimal places explicitly when the Representation was set with options other than Auto.

Decimal Places

Currency Culture

You can set the currency value culture when the value display type was set as Currency.

Currency

Decimal and Group separator

You can set the decimal and group separators for the value.

Decimal separator:

Decimal Separator

Group separator:
Group Separator

The decimal separator should be replaced with only symbols and special characters and the Group separator can be replaced with any value.

NOTE

You shouldn’t use the same values in decimal and group separators.

Negative Values

You can set the negative value display format for number representation.

Negative Values

Append Text

You can append text, character, number or symbol either at start or at the end of the values.

Append Text

Preview

This pane at right of Measure Formatting dialog will preview the display value based on the settings you change.

Preview