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
hb0135
Helper III
Helper III

How to get Jan-24 to last of Dec-23

Hello,
I want in my graph month Jan-24 should come after Dec-23 and so on the other month of year 2024

hb0135_0-1701921381664.png

Thanks & Regards
hb0135

1 ACCEPTED SOLUTION
gmsamborn
Super User
Super User

Hi @hb0135 

 

Your MMM-YY column that you are using on the x-axis has to be sorted by a column with a number like this.

 

([Year] * 100) + [MonthNo]

 

ie. 202312 for Dec-23 and 202401 for Jan-24

 

I hope this helps.

View solution in original post

2 REPLIES 2
gmsamborn
Super User
Super User

Hi @hb0135 

 

Your MMM-YY column that you are using on the x-axis has to be sorted by a column with a number like this.

 

([Year] * 100) + [MonthNo]

 

ie. 202312 for Dec-23 and 202401 for Jan-24

 

I hope this helps.

Hello,

 

Thanks it work

Regards,
hb0135

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.