Formatting Measure Type Column

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


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.


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

Decimal places

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

Currency culture

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

Negative values

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

Append text

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


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