Months are nor sorting properly in custom calendar

[domi25]

Hi, I created custom calendar with different months in quarters and the months are not sorted properly. I tried to add month nr column and sort by 1) year 2) quarter 3) month number. Data is properly sorted in model view but when I try to display months in visual over time months are not sorted properly. I tried to fix it adding a month nr to hierarchy and it works good but I don't want to see month number in my visual and when I remove month number from hierarchy the months are not displayed correctly. It is possible to do this in other way to have months sorted correcly without month number displayed? 

[zenisekd]

@domi25 
This happens due to the fact, that text gets sorted by default alphabetically. Therefore you need to add a month num and quarter num to the table (as you have) and then sort the month name by this new number column. Problem solved. 

Kudos and mark as solution very appreciated! 🙂

[domi25]

This proposal does not solve my problem, or I don't understand what else I need to do. As I mentioned in the post, the data is already sorted correctly by the 'month number' column. The issue arises when I want to display a timeline on the chart without the 'month number' column in the visualization. My table looks like this: 

[zenisekd · Accepted solution]

You are not sorting the table. You are sorting the column. Click on the Month name column and then select "sort by column" and select Month Nr. 

Proper explanation is here: https://www.linkedin.com/pulse/sorting-months-chronologically-powerbidesktop-ace-mary-bajisma/

If your month name is sorted by the month number as I explained and your visual is sorted by the month name, then there should be no problem. 

[domi25]

Now I understand! It works properly. Thank you very much for your help!