Currency Formatting - research
1. Go to model view
1.
2.
3.
4.
2. In data type, choose Decimal number or fixed decimal number
3. In format choose ‘Custom’
4. In custom format provide the Custom Numeric Format String (this allows for precise control
over how numbers are displayed as strings, ensuring they meet specific requirements for
applications, reports, or user interfaces), where:
- Zero Placeholder (0):
Replaces the zero with the corresponding digit if one is present; otherwise, it displays a zero.
Example: 1234.ToString("00000") → "01234"
- Digit Placeholder (#):
Replaces the "#" symbol with the corresponding digit if one is present; otherwise, nothing is
displayed.
Example: 1234.ToString("#####") → "1234"
- Decimal Point (.)
Determines the location of the decimal separator in the formatted number.
Example: 1234.56.ToString("0.00") → "1234.56"
- Thousand Separator (,):
Inserts a thousand separator between each group of three digits to the left of the decimal
point.
Example: 1234567.ToString("#,##0") → "1,234,567"
- Percentage (%):
Multiplies the number by 100 and appends a percentage symbol.
INT
ER
NA
L
Example: 0.123.ToString("0%") → "12%"
- Per Mille (‰):
Multiplies the number by 1000 and appends a per mille symbol.
Example: 0.123.ToString("0‰") → "123‰"
- Exponential Notation (E0, E+0, E-0, e0, e+0, e-0):
Formats the number in scientific notation.
Example: 1234.ToString("0.00E+00") → "1.23E+03"
- Escape Character ():
Escapes the next character, allowing for literal characters in the format string.
Example: 1234.ToString("0\#0") → "123#4"
- Section Separator (;):
Defines different formats for positive, negative, and zero numbers.
Example: 1234.ToString("#;(#);0") → "1234", -1234.ToString("#;(#);0") → "(1234)",
0.ToString("#;(#);0") → "0"
note that custom number format strings in Power BI do not support changing the thousand
separator directly.
INT
ER
NA
L
