Toggle rules on/off. When ABS value ≥ threshold, that scale + decimals are used.
Select format style
Sample Output
Unformatted
Formatted
Format string
Dynamic format string
Additional formatting options
Zero values display as:
Negative values display as:
Thousands separator:
Trailing zeros:
Currency symbol:
Plus (+) sign for positive:
Variance indicator:
Variance indicators:
Indicator position:
Format String Finder for Power BI
Find, customize and copy format strings for Power BI. This free tool helps you build DAX format strings, dynamic format strings for measures, and custom format strings for data formatting in Power BI visuals (Format > Properties > Data format).
Supports number formatting for thousands, millions, billions with optional K, M, B suffixes. Format percentages and percentage points (pp). Choose between standard and variance styles with plus signs and directional indicators. Customize zero handling, negative value display with minus or brackets, thousands separator, and trailing zeros.
A format string in Power BI consists of three parts separated by semicolons: positive;negative;zero. Example: #,0.00;-#,0.00;0. Use in DAX with FORMAT([Measure], "format string") or as a dynamic format string in a measure.
How to use
1
Select a display category, format style and decimal places in the left panel.
2
Preview how your values will look in the sample output table.
3
Copy the format string for usage in Power BI.
Use Additional Formatting Options to customize zero handling, negative display, thousands separator, trailing zeros, currency symbol, plus sign for positive variances and variance indicators. Switch to Conditional to generate a DAX measure that automatically scales values based on their magnitude (e.g. K, M, B).
Format string structure
positive ; negative ; zero
#,0.00;-#,0.00;0 1st: positive 2nd: negative 3rd: zero
Good to know
This tool generates all three parts (positive ; negative ; zero) for full control over zero display. #,0.00;-#,0.00;0 — zero as 0 #,0.00;(#,0.00);– — brackets, zero as dash ▲ +#,0.00;▼ -#,0.00;"" — indicators, zero empty
Power BI uses two formatting engines that may interpret some patterns differently: Measure / Dynamic — for measure format strings and dynamic format strings DAX FORMAT() — for use inside the DAX FORMAT() function (returns text) When format strings differ between engines, an extra toggle appears in the format string box so you can select yours.