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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
littlepatos
Helper II
Helper II

Date not sorting by Year then Month - updated to include pBIX

I have a line chart visual that I need to sort via Year and Month so it should be Sept 2020, Oct 2020, Nov 2020, Dec 2020, Jan 2021, Feb 2021 etc

I created a new table to abbreviate the Month names (from Septembre to Sep) and have joined this to my date table. 

I am sorting by Year Month Abbrev Ascending

littlepatos_0-1681724616189.png

littlepatos_0-1681807841361.png

https://drive.google.com/file/d/1lsGVhogTsHzMsmzFqUpMk0YFTBJYFpUT/view?usp=drivesdk

https://docs.google.com/file/d/1etwKFEKKxP9BbTrIpnqUYXi3PkMRsdSH/edit?usp=docslist_api&filetype=msex...

 

1 ACCEPTED SOLUTION
littlepatos
Helper II
Helper II

I've added a month number then used the Column sort to define sort order and this worked

View solution in original post

2 REPLIES 2
littlepatos
Helper II
Helper II

I've added a month number then used the Column sort to define sort order and this worked

littlepatos
Helper II
Helper II

I have a column for month number but it only goes to 12 where I think I need it to go to 24? 

littlepatos_0-1682220063783.png

I tried a few methods to correct such as "Month Number", (YEAR([Date])-YEAR(MIN([Date]))) * 24 + MONTH([Date]) but this doesn't work.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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