How to SORT your DATES / MONTHS / FISCAL MONTHS in Power BI // Beginners Guide to Power BI in 2023

In this video we're going to look at a few ways you can ensure your calendar fields like months, or fiscal months are always sorted chronologically in Power BI.
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: [e-mail]
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

[@user-we2vx6pq9w]

OMG! You solved my problem in 2 minutes! Thank youuuuuu

[@tassosm.4790]

That was so helpful, thank you! Brief and to the point!

[@truewiking]

Brilliant explained and this solved my problem right away, thank you very much 🙏

[@srirajnambiar2318]

Awesome, Keep Going Bro❣

[@sw059]

Thanks this was great and to the point

[@karenwood8558]

Great and thanks 😊

[@kassiowifried]

❤ thank you

[@darsh48]

Hey is it possible to use this in slicer as a dropdown under fis year?

[@FridaDaniel]

Thank you for this! How would you change the Dax code if Fiscal Year starts in June?

[@bdehning00]

Ok great video. How do use this if my Power Bi report is used for many companies with fiscal years that can start from January to December?

[@thuytamdang3390]

Thank you very much. I am building report direct from Lake house, Date table create from dataflows then how to sort Month name there? Please help.

[@thuytamdang3390]

I've just found it.

[@user-go5zx8xo1w]

When I try custom sort a column containing only the text which is the "month name" using power query, then follow your instruction by going to Add Column and then the Date dropdown selections, all the selections except "Parse" are grayed out. What am I missing?

[@kennethskeie2500]

Great, thanks! This solved the problem where even Guy in a cube didn't have a solution that works :o)

[@sel4sie]

you can only download the demo unless you are patreon subscriber right?

[@navjotsayal]

my data does not have date column and i m allowed to only use dax

[@romainbarbou94]

And for a 18-month fiscal year ?