Format field options

The Format field for Properties allows users to select values based on numerals and calendar dates. Below is a list of supported numeric and date formats you can select for the field or measure.

Format field options

For more detailed information about numeric and date format strings, view this article about MDX and format definitions.

Format String	Result
0	12345
0.00	12345.09
#,##0	12, 345
#,###.00	12, 345.09
-#,###.00	-12, 345.09
(#,###.00)	(12, 345.09)
$ #,##0	$ 12, 345
$ #,##0.00	$ 12, 345.09
$ -#,##0.00	$ -12, 345.09
$ (#,##0.00)	$ (12, 345.09)
$ #,##0.00;(#,##0.00)	$ 12, 345.09
0 %	1234509 %
0.00 %	1234509.00 %
#E+#	1E+4
0.00E+00	1.23E+04
##0.0E+0	1.2E+4

Format String	Example
M/d	4/1
M/d/yy	4/1/16
MM/dd/yy	04/01/16
d-MMM	1-Apr
d-MMM-yy	1-Apr-16
MMM-yy	Apr-16
MMMMM-yy	April-16
MMMMM d, yyyy	April 1, 2016
M/d/yy h:mm AM/PM	4/1/2016 8:09 PM
M/d/yy h:mm	4/1/2016 20:09
M/d/yyyy	4/1/2016
d-MMM-yyyy	1-Apr-2016
h:mm	20:09
h:mm AM/PM	8:09 PM
h:mm:ss	20:09:06
h:mm:ss AM/PM	8:09:06 PM
[h]:mm:ss	[20]:09:06