Display date as MMM-YY but maintain date type

Question

I have a date column in my table:&nbsp;Date1/1/20222/1/20223/1/20224/1/2022&nbsp;I want to display the date in a matrix visual as "MMM-YY".&nbsp; I don't see that format as a choice in the format display options.&nbsp; If I use FORMAT(Date,"MMM/YY"), I lose the sorting by date as the column becomes text.&nbsp;It seems like this is an easy problem to solve.&nbsp; Is there any way to add a custom format type to the date Format drop down?&nbsp;Thanks.

mikelytics · Accepted Answer

Hi&nbsp;ConnieMaldonado&nbsp;&nbsp;you can transform the data in Power Query when you load the data into POwer BI.&nbsp;Date.FromText([Date],[Format="M/d/yyyy"])&nbsp;Please make sure to write months in capital M and the restr in small letters.&nbsp;Date.FromText - PowerQuery M | Microsoft Learn&nbsp;Best regardsMichael-----------------------------------------------------If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.Appreciate your thumbs up!@ me in replies or I'll lose your thread.-----------------------------------------------------LinkedIn

Forum Discussion

Display date as MMM-YY but maintain date type

2 Replies

Related content

Date format mmm-yy

m code - mmm-yy

Date Format MMM-YY

Sort Chronologically MMM-YY Date

From YYYYMM to mmm YY