Custom numeric format #’##0.00 doesnt work

[Anonymous]

hello,

the format #’##0.00 in power data model doesnt work as in Excel. It works only for 6 digits for example: 123'456.00

but for numbers with 7 digits an more it does not work. it formats numbers like this 9123'456.00   but it must be like this 9'123'456.00

[v-cazheng-msft]

Hi @Anonymous 

I can repro it and this issue has been reported internally(ICM 281827606). Will sync here once there is any update.

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Hi @Anonymous 

According to the reply from product team, Format strings always interpret comma (,) as the thousand separator. Escaped apostrophe (') is simply treated as a character literal. Since your intention is to change the thousand separator to apostrophe ('), you should not change the format string, but change the region setting to a region that uses apostrophe as the thousand separator such as Switzerland. This document supported-languages countries regions describes how to change region settings in Power BI Desktop. Please note that changing region settings only affects future new models but won't affect existing models.

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

thank you it works perfectly!