Forum Discussion
Solved
Months not in order
Hello
I have date which date is from December 2017 to April 2018.
In the visualization, the order of month is from January to December as below.
I want to have the order from December (2017) to April (2018).
How can I fix it?
5 Replies
- Greg_Deckler
Community Champion
Perhaps something like this:
MonthSort = IF([Month]="December",0,MONTH([Date]))
Hi danextian
Thank you for replying to my question and now I can sove the problem!
Thank you so much.
It's easy problem but I'm not familiar with PowerBI yet.
So if you know some web page telling the diference between "expand down one level in the hieranchy " and "go down to the next level", please let me know.
Thank you.
