Sort Graph by Month and Year

Question

Hi All,&nbsp;Help needed. Can I have this graph sorted to have (left to right), Jan 2018, Dec 2017, Nov 2017 so on...?&nbsp;Thanks,Paul

jordanjsa · Answer

Hi Polaris,&nbsp;You could create a new column in your table in the query editor and input the order in which you wish to see the dates by creating an index e.g.Jan 2018 = 1Dec 2017 = 2Nov 2017 = 3Once you've done that then sort the graph via the index created. But i would advise creating the table oldest date to newest for ease of use.&nbsp;

polaris3028 · Answer

Hi Jordan,&nbsp;Actually, the X-axis I used in this graph is from a Date table using the combined fields of month and year.&nbsp;&nbsp;InsertCalendarMonth = Table.AddColumn(InsertMonthName, "MonthInCalendar", each (try(Text.Range([MonthName],0,3)) otherwise [MonthName]) &amp; " " &amp; Number.ToText([Year])),&nbsp;Can you walk me through on how I can create a new column with index as suggested above?&nbsp;Thanks

jordanjsa · Answer

Hi Polaris,&nbsp;&nbsp;Okay, what source did you upload the data from? Excel?&nbsp;&nbsp;&nbsp;

polaris3028 · Answer

Hi&nbsp; Jordan - not sure what source of what data you're asking.&nbsp; The Date table was created in PowerBI itself (as a query).&nbsp; The data is coming from Google sheets.&nbsp;&nbsp;So, basically I have two tables, one as datasource and a Date table for the calendar.&nbsp; The X-Axis presented in this graph that I wanted to sort out is using the concatenated Month and Year columns from the Date table.&nbsp; If I have to create a new column like what you said with Index, which table should I create it? and How?&nbsp;Thanks&nbsp;

jordanjsa · Answer

Hi Polaris,&nbsp;&nbsp;I've been looking into this and I'm not sure that this can be done within PowerBI. The index feature within PowerBI naturally orders the values 1,2,3.. Which wouldn't return the output you need. An alternative would be to create the index within Google docs if possible and then once loaded into PowerBI you would have the order that you require and you could sort by this value.&nbsp;&nbsp;thanks&nbsp;

Forum Discussion

Sort Graph by Month and Year

6 Replies

Related content

sorting months in order

Help with line graph sorting

DAX Table Sorting Months

Sorting graph based on fiscal month.

Months Not Sorted Correctly