cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Microsoft
Microsoft

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 Impactful Individual
Impactful Individual

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.

Microsoft
Microsoft

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

Highlighted
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
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors