Displaying Dates

It is possible, yes.  You would need to add 2 calculated columns to your Calendar table.  1 for the display value and 1 to sort the display value into the correct order.

First the display value:

Month Year Prior = 
IF ( YEAR ( [Date] ) < YEAR ( TODAY() ) - 1, "Prior to " & YEAR ( TODAY() ) - 1, FORMAT ( [Date], "mmm-yy") )

 Then the sort order:

Month Year Prior Sort = 
IF ( YEAR ( [Date] ) < YEAR ( TODAY() ) - 1, 1, YEAR([Date]) * 100 + MONTH ( [Date] ) )

Make sure to select the [Month Year Prior] column and set the sort by to [Month Year Prior Sort]:

Then add the [Month Year Prior] to your chart.

The column is dynamic, so in 2024 it will show 'Prior to 2023' and grab all those dates.

Hi,

you can obtain this

by adding  a calculated column

YM = 'Date'[Year]&FORMAT('Date'[Month Number],"00")

and then creating a group

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!