cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
metricsman
Helper I
Helper I

Date format changing desktop to web

I have a dashboard that when publishing to web the format of the date in the slider changes. 

 

Example on desktop:

 

Screen Shot 2017-01-23 at 1.19.59 PM.png

The date is in "uk' format, DD/MM/YYYY

 

but when published the same slider shows in USA format when acessing it on the web:

 

Screen Shot 2017-01-23 at 1.25.16 PM.png

 

Strangely on both other formats such as list show "uk" format:

 

Screen Shot 2017-01-23 at 1.30.53 PM.png

 

The original date is of the format YYYY-MM-DD, ie 2017-01-31 which is "transformed" on input using locale (uk).  Modelling setting then used to get the required display format.

 

Seems strange that on the web, list is UK format, select between/before/after is USA format, any ideas ?

 

Thanks!

 

1 ACCEPTED SOLUTION
JonBaylis
Advocate II
Advocate II

CC: @WillT 

 

Hi all,

 

Fixed it!!!! - Well my DBA colleague found the solution.

 

The reason it was working for some users and not others is the following:

 

When a user had their default language set to English UK then their language setting in Power BI would remain unset.
When a user had their default language set to English US then their language setting in Power BI would get set to English.


(This is why we had some users working properly)

 

There appears to have been an update on the Power BI Service recently that allows you to set the language setting to respect the browser settings again.


(This was not the case earlier this year http://community.powerbi.com/t5/Service/Language-Settings-Power-BI-Cannot-set-to-British-English/td-... )


This means, you can now correct your language in your browser and then setting the Power BI Service language to default and the issue should be fixed.

 

To do this:

 

Change your browser language to English (UK) (or relevant language).

 

IE: Set IE Default Language (same for IE 11)

 

Chrome: Set Chrome Default Language


Then, in the Power BI Service, under Settings > Language, set it to Default (browser language).

 

Choosing this means the dates in my reports are now in the correct format, DD/MM/YYYY. Smiley Happy

 

Thanks,
Jon

 

Twitter: @JonBaylis

View solution in original post

25 REPLIES 25
Anonymous
Not applicable

THIS IS ABSURD!!! How can the browser language define the date format being loaded via gateway??? Smiley Mad

My project is pt-BR, DD/MM/YYYY, but I share with a branch in China, thus the Power BI Service must be in English, which is MM/DD/YYYY. I cannot lock my browser and PBI Service in pt-BR, but my data must stay DD/MM/YYYY as it is in my pbix! Smiley MadSmiley MadSmiley MadSmiley MadSmiley MadSmiley MadSmiley Mad

Hi , I'm sorry I don't find a solution despite any of your messages.

On my Desktop the date format is correct (ddmmyyyy) but on the webservice it becomes mmddyyyy, independantly from my regional settings, language etc.

On my computer regional language is French, on google chrome it is french as well, on PBI webservice it is set as default browser settings.

If I insert the ?language in the url it translates the interface but does not interfere with my date format.

 

 

StuC
Frequent Visitor

Yes, I'm still having the issue in both IE and Chrome. I've set the browser language to UK, set the language in the Power BI portal to Default(Browser) but it is still showing US format rather than UK.

 

Help please 😞

zivhimmel
Resolver I
Resolver I

I've written an article summarizing how to deal with the date format in date slicers. Here it is:

https://superfarb.com/power-bi-customising-date-format/

 

JonBaylis
Advocate II
Advocate II

CC: @WillT 

 

Hi all,

 

Fixed it!!!! - Well my DBA colleague found the solution.

 

The reason it was working for some users and not others is the following:

 

When a user had their default language set to English UK then their language setting in Power BI would remain unset.
When a user had their default language set to English US then their language setting in Power BI would get set to English.


(This is why we had some users working properly)

 

There appears to have been an update on the Power BI Service recently that allows you to set the language setting to respect the browser settings again.


(This was not the case earlier this year http://community.powerbi.com/t5/Service/Language-Settings-Power-BI-Cannot-set-to-British-English/td-... )


This means, you can now correct your language in your browser and then setting the Power BI Service language to default and the issue should be fixed.

 

To do this:

 

Change your browser language to English (UK) (or relevant language).

 

IE: Set IE Default Language (same for IE 11)

 

Chrome: Set Chrome Default Language


Then, in the Power BI Service, under Settings > Language, set it to Default (browser language).

 

Choosing this means the dates in my reports are now in the correct format, DD/MM/YYYY. Smiley Happy

 

Thanks,
Jon

 

Twitter: @JonBaylis

View solution in original post

Thanks for this - I only just noticed this formatting issue and you already had a solution for me.  Cheers!

Hi what about powerbi embedded how we can make sure what regional settings are being used?  I am dealing with a problem that my computer settings are different to what my customers expect and at the same time, I want to avoid having to change settings in my pc. What happened is that all date pickers in the embedded application were showing my (polish) date formatting I tried to solve it in data model by changing the data type with locale set to danish but it didn't help.  

Thank you. It fixed the problem!

Worked for me. Thanks a lot!

JonBaylis
Advocate II
Advocate II

Nice one guys.

 

It seems there might be some issue at our office whereas......

 

I am in an AD Group called Power Users and it seems us Power Users are having a problem where our IE/Chrome browser is NOT recognising its default language (where you have just changed yours now) so it is not having an affect and I see the US format for my dates. A couple of users who aren't in the Power Users Group are having no issues in IE/Chrome.

 

I am being removed from the Power Users Group and will test again when back in the office on Thursday.

 

Glad it works for you all..... I hope this Power Users Group is my issue and I can get it sorted ASAP. On the road to rolling out Power BI Smiley Happy

 

Cheers

Jon

(Twitter > @JonBaylis)

JonBaylis
Advocate II
Advocate II

Found a 'solution' which works when viewing the report on your PC/laptop.

 

If you open the report in the Power BI Service which has the date format issue; go to the URL and add this at the end.

 

?language=en-GB

 

Hit enter on the URL and the dates all format to English (UK).

 

However, this is not feasible to do each and every time so hence not a long-term solution.

 

The guy next to me sees the correct UK date formats without the need of any amendments (but only in IE and not Chrome) so we are thinking it is down to some sort of setting on the PC itself, even though we seem to have the same settings in Control Panel.

 

Arghhhhhh!!! Power BI Admins - please help! 😞

 

Thanks,

Jon

Thanks allot @JonBaylis

I tried chrome vs. IE now and you are correct. Which means that after 10 years I'm actually going to have to start using IE again.

That's fine, but telling my 35 users to do so might be painfull 🙂

Breaking news ! 

Following @JonBaylis findings, I've been able to solve the issue.

If you go to chrome settings, go to advanced settings and click on languages, 

just change from plain "English" to the flavour of english you are interested in(in my case New Zealand),

and choose for chrome to use it as its default language. Restart chrome and dates will show up according to your chosen language.

 

Capture.PNG

 

Capture.PNG

 

 

v-shex-msft
Community Support
Community Support

Hi @metricsman,

 

I can't reproduce your issue, all of these date fields shows the "US" format.(I test on 2.42.4611.701 64-bit (January 2017))

 

Capture.PNG

 

Capture2.PNG

Capture4.PNG

 

Can you share some detail content ?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi

 

Everything is okay in the desktop, it's when published that the slider changes date format although list view looks okay.

 

The machine using it on and viewing it once published is set to UK locale (system) and in powerbi desktop the locale is set to UK.

 

The data input is in the form:

 

2017-01-01

2017-12-31

 

which transposes correctly in the desktop due to the locale setting.

 

Wondering if there some form of locale setting on the web, the data location is UK though so would have though it would show UK primarly.

 

Many thanks for your help, is that above what you were asking for ?

I am having exactly the same problem - is it something caused by the February update? I am sure that it used to work. The desktop shows correctly and all the regional settings that I can find are set to UK, but when I post to the web service the date slicer changes to US format.

 

Any help would be much appreciated please?

 

Steve

Same issue here unfortunately. Really annoying because we are in New Zealand, using the dd/mm/yyyy format, 

and users are forced to view it the American way.

 

For my non US friends here, where is your Power BI tenant located?  I have encountered issues where the locale settings for the hosting servers control some of these features, and said servers may not be in your locale.

Good point, @dkay84_PowerBI

I think in my case(New Zealand) we are hosted in Australia, so the format should still be the way I want it to be.

 

Hi,

 

Has anyone found a fix for this? I am having the same problem as well.

 

Thanks,

Jon

 

@JonBaylis

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors