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

How do you sort month slicer on report by fiscal month? It keeps panning in alphabetical order

What if match is fiscal year then u have to choose multiple conditional columns in power query as well as in Dax to reiterate the solution. Instead u can use edate function for such fiscal possibilities and then sort

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?

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?

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

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

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.

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

And for a 18-month fiscal year ?

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

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

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

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

Thanks this was great and to the point

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

Awesome, Keep Going Bro❣

Great and thanks 😊

❤ thank you