Sort Months by dates in date table

[kap_55]

Hi,

I have my date table sorted by date and in visual my month are not sorted by by the date but by months alphabetically.
I have marked my table as date table too.

My date table:

My two visuals.

I disabled the hidden local date tables and created a hierarchy for above visual.

Does the hierarchy need to be sorted somehow?

Thanks for help.

K.

EDIT:

Calendar = 
ADDCOLUMNS (
     CALENDAR(DATE(1981;01;01);DATE(2080;12;31));
    "CALENDAR YEAR"; YEAR ( [DATE] );
    "MONTH NAME"; FORMAT ( [DATE]; "MMMM" );
    "MONTH NUMBER"; MONTH ( [DATE] );
    "WEEKDAY"; FORMAT ( [DATE]; "DDDD" );
    "WEEKDAY NUMBER"; WEEKDAY( [DATE];2 );
    "WEEK NUMBER";WEEKNUM( [DATE];21);
    "DAY"; DAY([DATE]);
    "QUARTER"; "Q" & TRUNC ( ( MONTH ( [DATE] ) - 1 ) / 3 ) + 1
)

EDIT2: File

https://drive.google.com/file/d/1AlsVzHyg0qV6WDkfE3-zf26xBT6oTA9z/view?usp=sharing

[Anonymous]

Try sorting the month by the month number under the modeling tab.

[kap_55]

I tried that before I posted and I does not work for me for some reason. Adding my dax to original post.

[amitchandak]

Sometimes the visual by default sort it on Value. Have you checked it is sorted on the month column?

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[BenFelder]

This worked for my date table sorting issue.  It was default sorting by a different value.  So I was able to sort by Month, and now my visual is in chronological order.

Thanks!

[kap_55]

I added link to my dummy file where I wanted to just create calendar table and I did exactly the steps from my original file and it still doesn't work, so you can check it.

[amitchandak · Accepted solution]

The sort column did not save correctly. I did it and it is working.

https://www.dropbox.com/s/ikvk0k3juemuqj9/SortMonthQ.pbix?dl=0