topic Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working in Report Server

Localization numeric formatting for "German (Switzerland) [de-CH]" not working

StolzHerz — Fri, 18 Aug 2017 08:24:52 GMT

Microsoft Power BI Report Server - June 2017 GA (on-premises)

In IE11 Internet Options, i set the language to "German (Switzerland) [de-CH]". Example number for de-CH should be 9'999.99

But in the rendered website, the number format is as example 9.999,99 which is "German (Germany) [de-DE]"

I guess only "German" is used for the number formatting localization, the culture part "Switzerland" is ignored...

Greetings, Roli

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

v-qiuyu-msft — Mon, 21 Aug 2017 01:33:33 GMT

Hi @StolzHerz,

Which kind of report( power bi report, rdl or mobile report ) did you deployed to Power BI report server and you wanted to format it as German (Switzerland) [de-CH]?

Best Regards,
QiuyunYu

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

StolzHerz — Tue, 22 Aug 2017 07:00:21 GMT

Hi QiuyunYu

It's a Power BI report. I deployed the report to the Power BI Report Server.

We have report readers around the world. Our headquarter is in Switzerland. I want that all users see the numbers formatted in their preferreded language and cultur, as it is defined in the IE 11 Internet Options under "Languages".

In Switzerland, the users have this IE 11 language settings: German (Switzerland) [de-CH]. But with this settings, the number format for de-DE is applied, not for de-CH. If I use other language settings, as example en-US, everyting works fine.

Greetings,

Roli

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

Dani74 — Fri, 03 Nov 2017 13:27:14 GMT

Hello everybody

Same problems still exist with current version October 2017 On-Premise. Problem exists with Excel Online, Power BI Reports. Excel called natively on the same tabular model is displayed correctly formatted.

Many thanks for further investigations through MS.

Daniel

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

Dani74 — Mon, 22 Jan 2018 08:35:11 GMT

FYI

Official answer from MS Premier Support at 18. january 2018.....

I know you have been already told that it is a limitation of Power BI.

Power BI product group have confirmed that this is a limitation of Power BI at this moment and hence this is a behaviour by design.

We do not have an ETA for fix to share with you at this point.

Also, we do not have any workaround to suggest.

I apologise for the delay and the inconvenience caused.

PS: Excel online still has the same issue (office online server)

Daniel

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

StolzHerz — Mon, 22 Jan 2018 08:55:52 GMT

Many thanks for the info, Daniel!

Fortunately, none of our users know how the formatting for de-CH should actually look like 🙂 Only programmers know that. So far I have no complaint from the departments because of the wrong presentation...

On the other hand, it is absolutely incomprehensible why Microsoft does not have the formatting under control. In .NET, it works without any problems. Why not in the used GUI library (JavaScript based?). Its an abolute basic feature.

Greetings, Roli

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

Dani74 — Fri, 23 Feb 2018 12:05:01 GMT

Update from MS premier support from 7. february 2018.....let's hope!!

"I have further escalated this. Though, it is not confirmed, PG is planning to release the fix April/May time frame. I believe , it will be fixed latest by May release of the Power BI release."

Dani

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

wilhelmF — Tue, 20 Mar 2018 10:56:09 GMT

May I ask if you received any news regarding this?

Thanks

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

Dani74 — Tue, 20 Mar 2018 11:35:24 GMT

No good news for them moment.

Error is still included in the latest version of March 2018. Will ask Microsoft Support if the fix will come in May as suggested before.

https://powerbi.microsoft.com/de-de/blog/power-bi-report-server-update-march-2018/#other

Dani

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

wilhelmF — Tue, 20 Mar 2018 11:43:59 GMT

Thank you very much

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

Dani74 — Wed, 21 Mar 2018 10:09:52 GMT

Be careful with installation of MARCH release from Power BI Report Server when you have also normal reports (rdl) with pictures in place! We just faced a problem with picture inside of tablix items, Pictures are not displayed correctly in some circumstances (fit to size, fit proportinal, clip). A case is opened and MS is working on the issue....

dani

Re: Localization numeric formatting for "German (Switzerland) [de-CH]" not working

Dani74 — Thu, 16 Aug 2018 14:17:56 GMT

Again the same bad news!!!!!

Error is still included in the latest version of August 2018. I will reopen the latest support case immediately.

Better everyobody who is affected from this error should open a case, maybe this could help to bring Microsoft more attention on this topic.

Dani