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
The value display format can be defined by the representation. For example, by selecting thousands, the value 10,000 will be displayed as 10K.
Lakhs and Crores support
Cultures from countries including India, Pakistan, Bangladesh, and Nepal have Lakhs and Crores support. For example, the value of 1,00,000 is displayed as 1L.
When support culture is selected, there will be a checkbox that is needed to enable lakhs and crores along with auto representation. This helps in handling existing value.
You can set the decimal places explicitly when the representation is set with options other than
You can set the currency value culture when the value display type is set as
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.