Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cocomy
Resolver I
Resolver I

Data type : Date Format : dd-mmm-yy

Hi All,

 

Suddenly,  date format : dd-mmm-yy dissapered.

 

I removed power BI and download again but it only gives me Japanese or yyy-mmm-dd selections.

 

Could you please help me how to return to original setting?

 

All the best,

cocomy

2 ACCEPTED SOLUTIONS
rocky09
Solution Sage
Solution Sage

did you checked the column in Query Editor? What date format it has? @cocomy

View solution in original post

RobertSlattery
Resolver III
Resolver III

Yes, it's a bug.  Aparently fixed in the latest version.

View solution in original post

9 REPLIES 9
abhijeet01
Frequent Visitor

I have Version: 2.87.762.0 64-bit (November 2020), and it do not have custome option for date. But have facility to type format. I tried something like SQL format as per image, and it worked for me. ( may be helpful for someone). Cheers!!!

 

abhijeet01_0-1605837765414.png

 

 

hourir2
Advocate I
Advocate I

Hi Guys,

For anyone that needs dates displayed as "dd-MMM-yy" for instance, you can create a measure:

formatdate = FORMAT(LASTDATE(date_table[date_col]),"dd-mmm-yy"), then pull the measure into your visual.

Sometimes You may need the original date_col values in your table but you can hide them at the end/off screen etc.

Anonymous
Not applicable

Has anybody else found the dd-mmm-yy format removed in recent versions again?

I am not getting DD-MMM-YY format option? how to get that

Anonymous
Not applicable

That format was only available in older versions of PBI Desktop. It's not available in the current version. I've had to go back to Jan 2018 to see that format

Is any way of getting this format back?. I do not see a "custom format" option as in Excel.

 

I really need my dates to show as DD/MMM/YY, since many people from different countries work with the same PBI model and I need to avoid confusion between Days and Months in dates.

RobertSlattery
Resolver III
Resolver III

Yes, it's a bug.  Aparently fixed in the latest version.

rocky09
Solution Sage
Solution Sage

did you checked the column in Query Editor? What date format it has? @cocomy

Thank you for your comment. It seemes a bag and now fixed.

 

All the best,

cocomy

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.