Display date as MMM-YY but maintain date type

[ConnieMaldonado]

I have a date column in my table:

Date

1/1/2022

2/1/2022

3/1/2022

4/1/2022

I want to display the date in a matrix visual as "MMM-YY".  I don't see that format as a choice in the format display options.  If I use FORMAT(Date,"MMM/YY"), I lose the sorting by date as the column becomes text.

It seems like this is an easy problem to solve.  Is there any way to add a custom format type to the date Format drop down?

Thanks.

[ConnieMaldonado]

Awesome!  I never knew you could do that.  Thank you!

[Mikelytics · Accepted solution]

Hi @ConnieMaldonado 

you can transform the data in Power Query when you load the data into POwer BI.

Date.FromText([Date],[Format="M/d/yyyy"])

Please make sure to write months in capital M and the restr in small letters.

Date.FromText - PowerQuery M | Microsoft Learn

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn