Rules / Formatting

Percentages should be formatted with thousands separators and 1 decimal

warning PERCENTAGE_FORMATTING · ported · scope: Measure

What it checks

Measures with a percent format string other than #,0.0%;-#,0.0%;#,0.0%.

Why it matters

Percentages formatted inconsistently end up side by side in the same report, so one card reads 12.3% while the next reads 12.34% or 12%, and the reader is left wondering whether the numbers disagree or only the formatting does. The three-part string this rule expects sets the positive, negative, and zero cases together, so a negative percentage keeps its sign and a thousands separator appears once values pass 1000%. Setting it on the measure fixes the presentation for every report that uses the model, rather than leaving each report author to format the visual by hand. This is house style rather than correctness: if your standard uses a different number of decimals, disable the rule in pbiplint.config.json instead of working around it.

How to fix it

Use the format string #,0.0%;-#,0.0%;#,0.0%. In Power BI Desktop, paste it into the Format box under Measure tools. In the TMDL file, set formatString: #,0.0%;-#,0.0%;#,0.0% under the measure.

Links

Check a model for this Improve this page