Forum Discussion
Post ProdigySorting the date table and it reflection on line graph
Hi there,
I have a date table which contains the Month name and Month Number. I setup Month Number in such a way that April considered as Month 1 and March treated as Month 12. I have sorted the column based on the Month number (as shown in the figure).
I am plotting a line graph on which the x-axis contains the Month name. I sorted the date column based on Month Number which means that the x-axis of the line graph shows the first month as April but still it shows January as its first name (as shown in the picture).
Could anyone help me in sorting out the issue?
hi Dunner2020 - You need to follow the below steps to sort the month column by Month number. If you follow the below steps the data should be displayed in the month order that you require.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
2 Replies
hi Dunner2020 - You need to follow the below steps to sort the month column by Month number. If you follow the below steps the data should be displayed in the month order that you require.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
- amitchandak
Super User
Dunner2020 , Sort column for
Month for FY April to March //File is attached after Signature
Month = format([Date], "MMM")
Start Of Year= STARTOFYEAR('Date'[Date],"3/31")
Month Sort = DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH)+1 // mark this as sort columnfor CY
Month = format([Date], "MMM")
Month Sort = format([Date], "MM") // mark this as sort column
For Month Year
Month = format([Date], "MMM-YYYY")
Month Sort = format([Date], "YYYYMM") // mark this as sort column
Refer Steps :https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
In case you have FY other than
