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

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

Data type : Date Format : dd-mmm-yy | Microsoft Fabric Community

rocky09
Solution Sage
8 years ago
did you checked the column in Query Editor? What date format it has? cocomy
- cocomy
  Resolver I
  8 years ago
  Thank you for your comment. It seemes a bag and now fixed.
  
  All the best,
  cocomy
RobertSlattery
Responsive Resident
8 years ago
Yes, it's a bug. Aparently fixed in the latest version.
Anonymous
Not applicable
7 years ago
Has anybody else found the dd-mmm-yy format removed in recent versions again?
- pjaiswal
  New Member
  7 years ago
  I am not getting DD-MMM-YY format option? how to get that
  - Anonymous
    Not applicable
    7 years ago
    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
hourir2
Advocate I
5 years ago
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.
abhijeet01
Frequent Visitor
5 years ago
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!!!