Stacked Column Chart Sorting

[jonboylib]

I have a simple column chart displaying figures for each month of the year. Currently the chart is set to sort by month, it's beginning at 'Sep'. I would like to begin at 'Aug', as that's the forst month of my financial year. So, the first column should be 'Aug', then 'Sep, Oct, Nov, etc.'

See image of current display.

How can I achieve this?

I don't want to change the source data (import from Excel).

[Anonymous · Accepted solution]

Hi @jonboylib ,

As far as I know, we need to add a [Month Number] column to sort [Month] column. However, calculated column as johnt75 mentioned should not be a good way. Due to [Month Number] is a calculated column based on [Month] column, this will cause a circule error in data model. 

I suggest you to add [Month Number] in Power Query Editor by Conditional Column, and then use Sort by column.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

Add a calculated column which you can use as the sort column for the month. It could just be a simple SWITCH returning 1 for August, 2 for September etc up to 12 for July. Then set the Sort by Column for month to be the new calculated column