Forum Discussion
Solved
Date Priority
Hi everyone, I'm having trouble getting Power BI to recognize the year of the date as requiring higher priority than the month. Currently, when ordering dates from past to present, it will or...
you need to add another column in your model to sort your month columns
Add another columns like
Month Sort = FORMAT( DimDate[Date], "YYYY-MM")
and in modellig tab chooise your month column and in sort by column from the menu choose, Month Sort columns which you just created.
Let me know if you need further assistance.
irongriffin007,
Please follow the solution parry2k posted, you will get expected result as follows.
Add a columnResult
Best Regards,
Angelia
irongriffin007,
Please follow the solution parry2k posted, you will get expected result as follows.
Add a columnResult
Best Regards,
Angelia