Solved: Date Priority

irongriffin007 · ‎07-17-2018

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 order them as:

Jan 2016, Jan 2017, Jan 2018, Feb 2016, Feb 2017, Feb 2018, Mar 2016, Mar 2017, Mar 2018, etc.

Instead, I want it to order them as:

Jan 2016, Feb 2016, Mar 2016, . . . , Dec 2016, Jan 2017, Feb 2017, Mar 2017, etc.

As a result, the Rolling 12 Month Sum graph I made with dates on the x axis is off. Thanks in advance for the help.

parry2k · ‎07-17-2018

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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

v-huizhn-msft · ‎07-18-2018

@irongriffin007,

Please follow the solution @parry2k posted, you will get expected result as follows.

Add a columnResult

Best Regards,
Angelia