Month sort for column chart display

Hi folks,

I have some data from 09/2019 to current month. Despite having a reasonably comprehensive date table (provided), I’m having difficulty sorting a column chart to display data (from L to R) for Sept, Oct (2019) …… to Jan (2020). I’ve tested sorting the Calendar Table Date column using the CurMonthOffset column and that produces the correct L to R display but displays the CurMonthOffset values eg. -4, -3, -2 …. to 0. Zero being the current month, but I want the month names displayed and not other values that might be associated with the sort.

Any suggestions are more than welcome.

TIA john

PowerBIPro - CalendarTable.txt (7.7 KB)


Using your date table, if you sort your x-axis column by the MonthYearNum column you should get the result you want.

See sample below:


Hope this is helpful. Full solution file posted below.

1 Like

Hi Brian

Thnx heaps …. it worked a treat
Simple … but I just couldn’t ‘see’ it



Great – glad that was what you needed. I’ve been there too - enough times that I keep this cheat sheet on my desktop to keep the date table fields straight, and figure out which column I can use to sort which other columns.

  • Brian

1 Like