Sorting the month name in ascending order instead of month number

[rachelbi]

Hi there, 

I created a graph showing the data in current month and upcoming 3 month, i.e. Apr to Jul, including months even has no data (e.g. Jun). I would like to change the month number into month name by using the date table. However, the month name cannot show the missing month data (e.g. Jun) and in wrong order (prefer ascending).

Appreciate for any help!

After change to "Month name", June data missed, not in acsending order, and I worry in the graph still be correct from 2024 Dec to 2025 Mar (whether be able to show the correct order in the x-axis).

My date table seems correct btw:

[manvishah17 · Accepted solution]

Whenever you want to sort your month name in proper order ( jan, feb...) then always sort it by month number. 
DAX TO CREATE BOTH COLUMN ARE  :

Month = FORMAT((DateTable[Date]), "mmmm")

MonthNo = MONTH(DateTable[Date])

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

[AMeyersen]

First, you need to sort your column [Month Name] on column [Month] to make sure it's sorted (Jan, Feb, Mar, ... ) instead of (Apr, Aug Dec, ... )

Then you need to sort your chart by [Month Name]

to show empty months in the graph, select "Show items with no data" on column [Month name]

[rachelbi]

Thanks. I did sort by monthyear, but still cannot sort the month name in the graph..

[AMeyersen]

Hi @rachelbi ,

the way it looks, "sort by column" has not yet fully worked.
You need a [month number] column in your date table which only includes the month number (1 for January, 2 for February ...).
Then you need to sort the [month name] column by [month number]

This video explains the issue and its solution step by step:
https://www.youtube.com/watch?v=NlX7Cp2P0d4