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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors