Format String Builder
Show $1.2M instead of $1,234,567.89, negatives in parentheses, or a dash for zero. Pick the look, check it against real values, and copy the format string, or the dynamic format expression when you want K, M, and B chosen automatically.
Format string
Select the measure, then type this into the Format box on the Measure tools ribbon.
\$#,0.0,,"M"Same format as text, with FORMAT()
Only for titles and labels: FORMAT() returns text, so the result no longer sorts or sums as a number.
FORMAT([Total Sales], "\$#,0.0,,""M""")Preview
| Stored value | Displays as |
|---|---|
| 2345678901 | $2,345.7M |
| 1234567.891 | $1.2M |
| 45210.5 | $0.0M |
| 987.65 | $0.0M |
| 0 | $0.0M |
| -8650.25 | -$0.0M |
Each comma at the end of the number part divides by 1,000 for display only; the stored value is unchanged. In a format string, the comma and period mean “thousands separator” and “decimal point”, so a model with a German or French locale shows them its own way.
Free, with no sign-in and no request limit. Everything runs in your browser, and nothing you type is sent anywhere.
Why not FORMAT() everywhere? A format string only changes how a number is displayed, so the measure still sorts, totals, and exports as a number. FORMAT() turns it into text, which breaks all three.
Building the measures themselves? See Measures, or browse all the Power BI tools.