how to sort data in chart

[MostafaGamal]

Hi all, i have a table is use in a chart as the below

when i put this data in chart it starts with April ( sorting alphapticaly ) but i want the data to start with july - august as the table 

[Tahreem24 · Accepted solution]

Hi, 

Try to create a  column for Month like:

Month ID = Switch(Table[Month], "July", 1,"August", 2, "September ", 3,.....)

Likewise, complete all 12 month. Then go to Data Tab (just  above relationship tab at left most pane) then Select your Month Column then you will see "Sort by Column " option on the top menu where you need to select the Month ID (Above calculated column).

So automatically your chart will get sorted as per your Month ID.

[v-stephen-msft · Accepted solution]

Hi @MostafaGamal ,

You try to add a Conditional Column in Power Query Editor as follows. Then select Month column to sort by this new column.

You can check more details from here.

Best Regards,
Stephen Tao

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

[MostafaGamal]

@v-stephen-msft 

I have tried this but the same problem 

[Tahreem24 · Accepted solution]

Hi, 

Try to create a  column for Month like:

Month ID = Switch(Table[Month], "July", 1,"August", 2, "September ", 3,.....)

Likewise, complete all 12 month. Then go to Data Tab (just  above relationship tab at left most pane) then Select your Month Column then you will see "Sort by Column " option on the top menu where you need to select the Month ID (Above calculated column).

So automatically your chart will get sorted as per your Month ID.

[MostafaGamal]