Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Sorting 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 ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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