Sort Year Month Column in Power BI

[@SonharaProject]

Thank you for the video, it's very useful

[@Computergaga]

You are welcome!

[@myl5837]

Thanks. This is almost the most usable Universal solution to the Month (x-axis) problem. Preparation though is to have a 'Month Number' Column in the csv or excel before one imports into Power BI.

[@Computergaga]

Thank you.

[@bharatarse1503]

Really helpful...Thank you😊😊

[@Computergaga]

Most welcome 😊

[@gabriel4w]

Thank you very much

[@Computergaga]

Any time 👍

[@user-ct1on1hy8t]

thanks allot. It's very useful

[@Computergaga]

Great! You're welcome.

[@velocitypta]

Thanks

[@Computergaga]

You're very welcome.

[@nadermounir8228]

Thank u for this nice video 📹 👍

[@Computergaga]

Most welcome 😊

[@garethwoodall577]

Thanks Al. Is there any variation to this to sort in financial year order?

[@Computergaga]

You're welcome. No variation, Gareth.

[@PerkP]

There's no year option for me when entering the formula, I can only select ' CALENDAR' or 'CALENDARAUTO' What shall I do?

[@adlaalnajmi9162]

How to do it in power query?

[@Computergaga]

If the date table is created in Power Query, you can use a Custom Column that usess this formula to generate the index column.
Than back in Power BI, use the Sort by Column feature.

[@user-qz5uy9kh8b]

Thanks so much it was very helpful and useful ❤

[@Computergaga]

You’re welcome 😊