Date format changing desktop to web

[metricsman]

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

Example on desktop:

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:

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

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!

[zivhimmel]

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 🙂

[zivhimmel]

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.

[v-shex-msft]

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))

Can you share some detail content ?

Regards,

Xiaoxin Sheng

[metricsman]

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 ?

[Anonymous]

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

[zivhimmel]

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.

[dkay84_PowerBI]

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.

[zivhimmel]

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.

[JonBaylis]

Hi,

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

Thanks,

Jon

@JonBaylis

[emarc1]

Same here. Didn't notice this till yesterday so perhaps it's a new bug.

s

[emarc1]

Same here. Didn't notice this till yesterday so perhaps it's a new bug.

s

[v-shex-msft]

Hi @metricsman,

 I reproduce the issue by modify the "Formats" setting at "Region". Based on test, it seems like the date records stored with a fixed format at service side. You can post this scenario to ideas.

In addition, you can also add a calculate column to transfer the date to text format. then use the new column as the date source of the slicer.

Regards,

Xiaoxin Sheng

[metricsman]

Hi

Great that you managed to reproduce it, I will definitely add it to ideas.

Could I check what you mean by "Format" setting at "Region" ? so I can detail the issue correctly.

I did try transferring the date to text format but then the silder doesn't provide the between/before/after functionality. As expected I think as it's not a date format and can't see a way to change the format once on the server.

Thanks again.

[v-shex-msft]

Hi @metricsman,

>>Could I check what you mean by "Format" setting at "Region" ? so I can detail the issue correctly.

It means the region panel of system setting.

>>I did try transferring the date to text format but then the silder doesn't provide the between/before/after functionality. As expected I think as it's not a date format and can't see a way to change the format once on the server

Yes, If you transfer date type to text, the date range feature of slicer will be disabled, I also haven't found a solution to solve this issue.

Regards,

Xiaoxin Sheng