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

[@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 🙏

[@NataliaPessoa-s4q]

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

[@sw059]

Thanks this was great and to the point

[@srirajnambiar2318]

Awesome, Keep Going Bro❣

[@kennethskeie2500]

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

[@karenwood8558]

Great and thanks 😊

[@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?

[@namangarg7023]

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

[@sel4sie]

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

[@VictorKap]

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

[@kassiowifried]

❤ thank you

[@RomanDylanFierro]

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?

[@darsh48]

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

[@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.

[@navjotsayal]

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

[@romainbarbou94]

And for a 18-month fiscal year ?