Formatting Measure Type Column

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

Type

The value display type of measure column can be defined based on the displayed data. For example, if you display the sales amount column, then the type can be defined as Currency.

Type

Representation

The value display format can be defined by the representation. For example, by selecting thousands, the value 10,000 will be displayed as 10K.

Representation

Decimal places

You can set the decimal places explicitly when the representation is set with options other than Auto.

Decimal

Currency culture

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

Currency

Append text

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

Append text

Preview

This field provides the preview of display value in the Measure Formatting dialog based on the settings.

Preview