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: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

mike_honey

Locale Date Time Formats (with *) show as M/d/yyyy in menu (Jan 2018 update)

Submitted by Memorable Member on ‎01-10-2018 10:18 PM

In Power BI Desktop Jan 2018 release, with a Date or Date/Time field selected in the Fields pane, when you navigate to the Modeling ribbon / Format / Date Time menu, the options at the top (marked with an *) that respect the machine locale now show in US format (e.g. M/d/yyyy) on machines with non-US locales e.g. English (Australia).

 

This appears to only be a problem in the display of the menu.  When date fields are shown in a visual e.g. a Table, the expected non-US locale is used e.g. d/M/yyyy.  

 

This issue was introduced with the Jan 2018 update to PBI Desktop.

Status: Accepted
See more ideas labeled with:
33 Comments (33 New)
Comments
Anonymous
Not applicable
‎02-07-2018 07:45 AM

Confirmed that standard date slicers relative date slicers are both showing US format dates only. Having to explain this to my customers as an issue with Microsoft's latest product update. Hoping for a fix soon.

mike_honey
Memorable Member
Memorable Member
‎02-10-2018 02:49 PM

From my tests its definitely affecting Slicers as well now, but not other visuals. I checked existing and new columns, existing and new visuals, brand new PBIX.

 

Others are reporting issues in the web service - I'm not seeing that. Slicers (that appear wrong (US date format) in PBI Desktop) appear correctly formatted (DD/MM/YYYY) in a browser (Chrome).

 

Confusion reigns for another month ...

mike_honey
Memorable Member
Memorable Member
‎02-12-2018 08:28 PM

As this issue is rather complex/messy to communicate, I put together this summary:

 

PBI date format issues 2018-01.PNG

mike_honey
Memorable Member
Memorable Member
‎02-14-2018 09:16 PM

I just tried the new build 2.55.5010.641 released 13 Feb 2018, but this issue persists as with the earlier 9 Feb 2018 release.

 

I did just notice that in a Table visual, Date/Time fields formatted as date/time (the first entry under "Common date formats") appear incorrectly in MM/DD/YYYY HH:MM;SS, where as those formatted as date only appear correctly as DD/MM/YYYY.  

 

That's unbelievably sloppy work by someone ...

mike_honey
Memorable Member
Memorable Member
‎03-07-2018 06:24 PM

I just tried the new build 2.56.5023.861 64-bit (7 March 2018), and ... yeah .. na ...

 

The menu issues have been resolved - great.

 

The presentation issues in Slicers, Tables & Matrix are still there - very very disappointing. 

 

kimani
Power BI Team
Power BI Team
‎03-09-2018 11:41 AM

We have a fix coming for the slicer issue in a QFE. I'll update the thread when the download is available. Sorry about the trouble here. 

mike_honey
Memorable Member
Memorable Member
‎03-12-2018 04:13 PM

@kimani thanks for the update.  Will that fix also cover the issues with Table & Matrix visuals described above, and the numeric formatting issues described on this post?

 

https://community.powerbi.com/t5/Issues/Date-slicers-are-fixed-to-US-date-format-since-Feb-2018-Upda...

 

MFelix
Super User
Super User
‎03-13-2018 05:03 AM

 Hope this get's fixed soon.

 

Regards,

MFelix

kimani
Power BI Team
Power BI Team
‎03-13-2018 09:41 AM

A new Power BI Desktop build has been released with a fix for the slicer date format issue. Please install via the download center or Windows Store and give it a try. Let me know if you still run into issues. 

MFelix
Super User
Super User
‎03-13-2018 09:52 AM

On my part this is solved on the slicers and tables 

 

Regards,

MFelix

Idea Statuses