Show the values for the last 12 months starting from the current month

[AmiraBedh]

I am using a live connection to an SSAS tabular cube, my measure is like below : 

StartedMeasure =
CALCULATE (
COUNT(Fact_Product[SK_product]),
dim_status_product[status] in {"Started"}
DATESINPERIOD (
dim_calendrier[id],
MAX ( dim_calendrier[id] ), 
-12, 
MONTH
)
)

InprogressMeasure =
CALCULATE (
COUNT(Fact_Product[SK_product]),
dim_status_product[status] in {"In Progress"},
DATESINPERIOD (
dim_calendrier[id], 
MAX ( dim_calendrier[id] ), 
-12, 
MONTH 
)
)

My current visual is like below : 

I want the X-axis to be displaying the count by month not by date :

If the current month is june : the X-axis will start from June 2021 to June 2022

[FarhanAhmed]

Create a column in your Date Dimension "Year-Month" and display it in x-axis instead of date column

[AmiraBedh]

And how to display the values in the month-year order?

[FarhanAhmed · Accepted solution]

Create a MonthKey Column in Dte Dimension with "Year & MonthNumber" concatenated i.e. 202201 ,202202,202203 etc

and then use the Sort by other column property for your "Year-Month" column to sort at chronological order.

[AmiraBedh]

I followed the same logic but the visual is not showing only the last 12 months, it goes beyond :