Thank you for good explanation, but i could not find a solution to my issue from the above video, I have created a excel work sheet with the list of months for 2023 and 2024 with 2 columns, how can I arrange the months in chronological order, do I need to clean the data in power query, (if I click new group I see a different screen) appreciate if you could help me.
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?
That was so helpful, thank you! Brief and to the point!
OMG! You solved my problem in 2 minutes! Thank youuuuuu
Brilliant explained and this solved my problem right away, thank you very much 🙏
Perfect!
Awesome, Keep Going Bro❣
Thanks this was great and to the point
Great and thanks 😊
Thank you for good explanation, but i could not find a solution to my issue from the above video, I have created a excel work sheet with the list of months for 2023 and 2024 with 2 columns, how can I arrange the months in chronological order, do I need to clean the data in power query, (if I click new group I see a different screen) appreciate if you could help me.
❤ thank you
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?
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
Hey is it possible to use this in slicer as a dropdown under fis year?
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.
I've just found it.
Thank you for this! How would you change the Dax code if Fiscal Year starts in June?
you can only download the demo unless you are patreon subscriber right?
Great, thanks! This solved the problem where even Guy in a cube didn't have a solution that works :o)
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?
How do you sort month slicer on report by fiscal month? It keeps panning in alphabetical order
my data does not have date column and i m allowed to only use dax
And for a 18-month fiscal year ?
tooooop