Waterfall chart decimal separators format

[Stepik]

Dear community,

I am working with Power Bi desktop where building a waterfall chart. Unfortunately, I can not change a number format to separate with dots instead of commas as presented in the screenshot. My Windows Region settings have been reflecting dot format, however Power Bi Desktop still shows comma separator, whereas a Power Bi application shows dot format.

Coudl you please assist?

Thanks,

Stepik

[freginier]

Hi @Stepik,

This discrepancy between Power BI Desktop and the Power BI service regarding decimal separators is a known issue tied to locale settings.

Power BI Desktop uses its own locale settings, which may differ from your Windows regional settings. Here is how to fix it:

1. In Power BI Desktop, go to File → Options and settings → Options.
2. Under Regional Settings (in the Current File section), change the Locale for import to match your desired locale (e.g., "English (United States)" uses dot as decimal separator).
3. Also check under Global → Regional Settings and make sure the locale is consistent.

Additionally, for the waterfall chart specifically:

- Go to the Format pane → Data labels.
- You can set a custom format using a format string like #,##0.00 depending on your locale.

If the issue persists after changing the locale, try creating a new measure with an explicit format string using FORMAT([YourMeasure], "#,##0.00") and use that in the visual.

Hope this resolves your issue!