Forum Discussion

jonboylib's avatar
jonboylib
Frequent Visitor
4 years ago
Solved

Stacked Column Chart Sorting

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 m...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
johnt75
Super User
4 years ago

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