How to Sort Months Chronologically in the filter?

[Jason2500]

Hi

I have a start date column as below

I extracted month and Year in the Power Query and added as an "Add Column"

I have created a filter for "Year" and "Month" as below

I would like to get the month in the chronological order. I tried to use the Data tab and sorted the column by month but not successful. Please advise.

[amitchandak · Accepted solution]

@Jason2500, In power Query you can also get date.month

Month No = Date.Month([Date])

https://docs.microsoft.com/en-us/powerquery-m/date-month

Or in Dax

Month No= Month([Date])

You can mark Month NO as sort column for month.

Refer my Video for that - https://www.youtube.com/watch?v=KK1zu4MBb-c

Or Refer this blog -https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Jason2500]

Thanks @amitchandak . It worked. Subscribed your channel as well. Good stuff.

[parry2k]

@Jason2500 you need to use sort by column technique, basically, add another column to extract month number and then sort this month name column by month number column.

Check my post here and here I talk about sort by.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡