default sort for a field Month Year

[MikeSolvesBI]

Hello,

I created a field "Month Year" from the Date field using  Date.ToText([Date],"MMM-yyyy").

When I create a table with just this field is sorts alphabetically.

How can I get this field to sort by the actual date.

Jan-2022

Feb-2022

Mar-2022

Instead of

Apr-2022

Aug-2022

Thank You,

Michael

[AlB · Accepted solution]

Hi @MikeSolvesBI 

1. Create another column MonthYearNum

MonthYearNum = YEAR([Date])*100 + MONTH([Date])

2. Sort your existing column [Month Year] by the newly created MonthYearNum:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

3. Sort in the visual based on Month Year as required

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.