Sort Filter by Year

[adityavighne]

Hi Team,

Is there any way to sort the filter by year in Power BI desktop?

Can I sort this by year so 2018 and then 2019 Months in order?

[jdbuchanan71 · Accepted solution]

Hello @adityavighne ,

You can, yes.  You will need a column on your table that calculates a number to use for sorting the column.  Something like this:

YearMonthSort = YEAR([Date])*100 + MONTH([Date])

Then you select your Year Month column in the table view and go to Modeling > Sort by Column and pick YearMonthSort

[adityavighne]

Thank You!