cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gooranga1 Impactful Individual
Impactful Individual

Date Formats on Date Slicers are US format ONLY

With the Feb 2018 update the date slicers like the mobile app on android are now all US format. There is no way to change this even with my regional settings set to uk and my laptop language set to UK???

 

This is particularly annoying. Also I cannot format dates to dd/MM/yyyy either that was broken in Jan 2018 update?

 

dateformat.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Date Formats on Date Slicers are US format ONLY

@gooranga1 @IAmDan @ThomasFoster

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
ThomasFoster Solution Specialist
Solution Specialist

Re: Date Formats on Date Slicers are US format ONLY

I have run into the same issue and have created an issue for this in the issues forum https://community.powerbi.com/t5/Issues/Date-slicers-are-fixed-to-US-date-format-since-Feb-2018-Upda...
IAmDan Advocate I
Advocate I

Re: Date Formats on Date Slicers are US format ONLY

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.

Moderator v-yuezhe-msft
Moderator

Re: Date Formats on Date Slicers are US format ONLY

@gooranga1 @IAmDan @ThomasFoster

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

yatinpurohit Helper I
Helper I

Re: Date Formats on Date Slicers are US format ONLY

Is this fixed? In India we use dd/mm/yy format and this is a BIG issue with users.

Warrenz
Frequent Visitor

Re: Date Formats on Date Slicers are US format ONLY

I'm in Australia and we use the same format as you, and I use the Power Bi service via Google Chrome.  I had your issue for many months.  To fix it, in Google Chrome settings make sure that the language is set to "English (United Kingdom)" and is set to "Display Google Chrome in this language".  Then go to your Power Bi Service settings and from the settings menu select General>Language> and make sure you select "Default (browser langauage)".  You might have to log out and log back in but it worked for me.  (update:  I've since changed my chrome setting to "English (Australia)" as I don't want to risk my currency field format switching from $ to £)

googlechrm.PNGpbsett.PNG

mmmg
Frequent Visitor

Re: Date Formats on Date Slicers are US format ONLY

Thanks Warrenz your suggestion worked for me (eventually). I say eventually because even though I set my language in Google Chrome settings to English (Australia) it wasn't at the top of the list so make sure you have it at the top of the list if you have more than one language. This can be achieved by clicking on the elipses to the right of the language that you want to move and select 'move to top'.

 

Google Language Settings.jpg

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors