FORMAT() turns a numeric measure into text
"FORMAT() turns a numeric measure into text" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) wrap their result in FORMAT(). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Keep the measure numeric and set a format string (or a dynamic format string); use a separate label measure only for cards and titles.
What is detected
n measure(s) wrap their result in FORMAT(). The measure becomes text: it cannot be plotted, sorted numerically or aggregated, and conditional formatting stops working.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Keep the measure numeric and set a format string (or a dynamic format string); use a separate label measure only for cards and titles.
Reference
Microsoft: Dynamic format strings for measures
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together