Forum Discussion
Helper Vhow to sort data in chart
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
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.
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.
4 Replies
Tahreem24Super User
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.
MostafaGamalHi 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
Anonymous
I have tried this but the same problem