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.

Anonymous's avatar
Anonymous
Not applicable
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.