To sort by FM and FY

[harshagraj]

Hello All I have Fiscal Month Coulumn and Fiscal Year column and I have created Calculated column as Fiscal Year & "-" Fiscal Month.

Now I need to sort like 2020-1,2020-2,2020-3,2020-4.... currently i have sorting like below. Kindly help

[amitchandak · Accepted solution]

@harshagraj , You have to create FY month Sort and mark it as sort column

How to create FY month sort

Refer: https://youtu.be/w4U6Bi_fPek

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[Greg_Deckler]

@harshagraj You will want to create a numeric column in Power Query that you can then associate with your column as a Sort By column.

[darentengmfs]

Hi @harshagraj 

If you have a date column, use that as a sort column for your Calculated Column.

Go to table view, click on the table, click on the Calculated Column, under Column Tools ribbon, click "Sort by column", and choose the date column.