Sorting the date table and it reflection on line graph

[Dunner2020]

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?

[amitchandak]

@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 column 

for 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

[Sumanth_23 · Accepted solution]

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!