Forum Discussion
Months in the wrong order
I made a spreadsheet with 3 tables. One of them relates Months, Results and goals. Only in the panel months are appearing in the wrong order. I would like it to appear in the order of the annual calendar. If anyone can help me I'll be grateful.
Panel Link: https://drive.google.com/drive/folders/0B1b9zTy_CQcRVmNjWjh0bURidlE
Link of source tables:https://drive.google.com/drive/folders/0B1b9zTy_CQcRVmNjWjh0bURidlE
8 Replies
- Phil_Seamark
Microsoft Employee
Hi fbjras12,
The default sort order for text columns is alphabetically so I'm guessing your months are sorting this way?
To fix you'll need another column to control the sort order. Preferablly using a numeric format.
I always add this column to my Date/Calendar tabales
MonthID = INT(FORMAT('Dates'[Date],"YYYYMM"))And use this option on my Month column to tell it to sorth by the MonthID column.
Thanks, but this appear. Link: https://drive.google.com/file/d/0B1b9zTy_CQcRV3M3WnByTEg3RVU/view?usp=sharing
Thanks, but this appear. Link: https://drive.google.com/file/d/0B1b9zTy_CQcRV3M3WnByTEg3RVU/view?usp=sharing
Try this in the Query Editor:
Table.AddColumn(<YOURLASTSTEP>, "YYYYMM", each "2017."&Number.ToText([Mes]))
