Charts blank outside en-US: the cause, and the one-line fix
LatestSeptember 2026
If a chart draws its axes, gridlines and labels but no line, bars or area — and only for some people in your tenant — this is why. It is the viewer’s region, not your data. Several people reported this over the past few months and were pointed at their lookups and column names instead. Those answers were wrong, and I’m sorry for the time they cost.
- ✓What happens. These charts draw by building an SVG out of text, and Power Fx
&converts a number using the viewer’s region. An account set to Dutch (Belgium) or Portuguese (Brazil) produces123,45where the SVG needs123.45; SVG reads that comma as a gap between two numbers and drops the shape. Whole numbers are unaffected, which is why the axes and text still draw — and why it never reproduces on an en-US account. - ✓The fix, in the copy you already have. Format each computed number where it joins the string:
Text(px, "[$-en-US]0.##"). Each affected component’s page now shows its own before and after, in the Installation section, so you do not have to re-copy the whole component. - ✓Affected: Line Chart, Bar Chart, Pie Chart, KPI Cards (the sparkline) and Data Table (the progress bars). Heatmap builds an SVG too and is notaffected — its grid lands on whole numbers.
- ✓One that looks fixed and is not.
Text(n)with no format string uses the viewer’s region exactly as&does. The KPI sparkline was written that way, so it broke in the same places as the charts that concatenated bare. The format argument is the part doing the work. - ✓Do not swap the commas back with Substitute. It rewrites every comma in the document, so thousands separators in your labels turn
1,420into1.420and comma-separated font stacks collapse. - ✓The import checker catches it now. A new rule flags a number going into an SVG without an invariant format, so the AI tools here will not write one, and it reports the ones already present.