Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
irongriffin007
New Member

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

2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

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
Employee
Employee

@irongriffin007,

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

Add a columnAdd a columnResultResult

Best Regards,
Angelia

View solution in original post

3 REPLIES 3
v-huizhn-msft
Employee
Employee

@irongriffin007,

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

Add a columnAdd a columnResultResult

Best Regards,
Angelia

irongriffin007
New Member

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
Super User
Super User

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.