cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DoubleJ
Responsive Resident
Responsive Resident

Regional Settings has no effect on number formats

Hi there

 

Version of Power BI Desktop: 2.42.4611.901 64-bit (January 2017)

 

I'm struggling with localized number formats. I want to have them displayed in Swiss German format. The regional setting applied in Power BI Desktop (File - Options and Settings - Options - Regional Settings - Locale)has no effect. In Power BI Desktop the number format is displayed the way I want it (Swiss German). But this is even the case when I set the PBI Desktop regional setting to another localization (e.g. English US). Shouldn't the number formats be changed according to the regional setting?

 

Anyway, after publishing the report to Power BI Service the numbers  are displayed in a different format (English US, I guess). No matter which browser or device I use: it's always the same.

 

Screenshot 1: Number format in Power BI Desktop

Screenshot 2: Number format after publishing

 

Desktop.PNGService.PNG

 

According to this blog post  when viewing a report in the browser the number format should be according to the browsers language setting. I checked with different browsers on different devices with varying language settings: The number format always remains the same.

 

Does anyone have an idea how to fix this?

 

Thanks a lot in advance!

JJ

9 REPLIES 9
StolzHerz
Helper I
Helper I

Hi

 

I have the same effect with Power BI Report Server 2017 on-premises (June 2017).

 

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

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

I guess they use only "German" as formatting parameter, the culture part "Switzerland" is ignored...

 

Greetings, Roli

Dani74
Frequent Visitor

nothing happens since months on this topic ;-(

Also in the august 2018 releas, still this important feature is missing.

Please try the way over "ms premier support channel" with a "critical design change request". you could linking your case to exisiting one "Case 118011117446788: reporting server region settings". without the pressure from many swiss german customers, NOTHING will happens.

BR

Daniel

 

Dani74
Frequent Visitor

 

Power BI Desktop August 2018 --> is working fine

Power BI Report Server August 2018  --> the issue still exists!

 

BR

Daniel

Dani74
Frequent Visitor

 

Power BI Desktop August 2018 --> is working fine

Power BI Report Server August 2018  --> the issue still exists!

v-sihou-msft
Microsoft
Microsoft

@DoubleJ

 

It seems the Power BI Desktop always takes the locale setting in your current system. However I still can't reproduce the your issue, the numbers keep same format in Power BI Desktop after I published. I suggest you change the locale setting in Power Query (query editor). For more details, see: Working With International Date And Number Formats In Power Query.

 

Regards,

DoubleJ
Responsive Resident
Responsive Resident

Hi Simon

 

Thanks for you answer. When viewing the report in the browser it is supposed to take the browser setting for formatting? I checked with different browser in all the language is set to German with no success.

 

I made a sample report: 

 

Link to report

 

Could you please have a look and let me know whether the number format are according to your browser settings? In the report there is a screenshot included that shows how it looks like in Power BI Desktop. 

 

Thanks alot!

JJ

DoubleJ
Responsive Resident
Responsive Resident

Am I the only one having this issue?

Yes - I have this problem EVERY time I publish in Canada.  The regional settings cannot be changed on the server as it dictates some of the information in the main application being used.

 

An override for this would be very helpful.

DoubleJ
Responsive Resident
Responsive Resident

In case someone else is experiencing this issue.

 

I got in touch with Microsoft. Their answer: 

As for the update from our product team, this is by design and they are working on ability to customize date format strings.

 

JJ

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.