Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Date slicers are fixed to US date format since Feb 2018 Update

Submitted by Anonymous on ‎02-07-2018 03:05 AM

As per the title all basic date slicers are stuck in the US date format and cannot be changed. My regional setting are set to UK and changing this around does not fix the issue.

Status: Accepted
See more ideas labeled with:
37 Comments (37 New)
Comments
IAmDan
Advocate I
Advocate I
‎02-07-2018 03:18 AM

I noticed this too this morning after updating to Version: 2.55.5010.521 64-bit (February 2018).

I'm only seeing this in desktop as when publishing to the service they display in UK format.

Regional settings are set to UK.

masplin
Impactful Individual
Impactful Individual
‎02-07-2018 10:45 AM

Actually we UK bods seem to have also lost all the sensible date format choices on the modelling menu. I use dd/mm/yy at lot but disapepared. We are now given a load of unusual or US format choices. The only UUK one is dd-mmm-yy. there is no point give UK regional choice users a choice of upside down US formats as just confused everyone this side of the pond.

 

I dont know if thisis related or a differnet issue?

 

 

Arie
Advocate IV
Advocate IV
‎02-07-2018 10:51 AM

Since the February 2018 update, I have the same issue.

 

Application language set to English (United States)

Model language set to Dutch

Locale for import set to Dutch

=> Then I can only choose the US dateformat (M/d/yyyy) and numberformats (99,999.00)

 

After this with the same file:

Application language set to Dutch

Model language set to Dutch

Locale for import set to Dutch

=> Then I can only choose the NL dateformat (d-m-yyyy) and numberformats (99.999,00)

 

So since the February update the dateformats and numberformats are no longer depending on the model language but are depending on the application language. Seems to be a bug.

 

 

masplin
Impactful Individual
Impactful Individual
‎02-07-2018 10:55 AM

where do you change the application language please?  

Arie
Advocate IV
Advocate IV
‎02-07-2018 11:04 AM

Under File > Options and setting > Options

Under Global > Regional settings

 

This option is only available in the version downloaded from the windows store.

masplin
Impactful Individual
Impactful Individual
‎02-07-2018 11:52 AM

I get my updates from the power bi link when the updates flashes up so is that different?  I only have a regional settings for current file nothing under the global bit of options?

Arie
Advocate IV
Advocate IV
‎02-07-2018 11:57 AM

Yes, that is the difference. This option is only available in the version installed from Windows Store.

 

https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions#choose-the-language-...

 

masplin
Impactful Individual
Impactful Individual
‎02-07-2018 11:59 AM

wierd. why would it be different. Is the application any different i.e. is there any issue if I switch source?

Vaillo
Frequent Visitor
‎02-07-2018 08:29 PM

I also updated my Power BI version to  2.55.5010.521 64-bit (February 2018) and I am having the same problem. I have tried several locales and always the US date format (which I hate). I can still see my old date columns and measures in the desired format (dd/MM/yyyy) but I cannot apply the same formatting to new ones. 

 

In Power BI service all works perfect as before. 

v-qiuyu-msft
Community Support
Community Support
‎02-07-2018 11:00 PM

Hi all,


The same issue has been reported before internally: CRI 56525764. The fix will be available in the March release.

 

Best Regards,
Qiuyun Yu

 

Idea Statuses