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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Organize data on column chart from the oldest data to the newest

Hi everyone, I have a column chart and I want to organize my data from the oldest data to the newest. In this case, for an unknown reason the data is organized like this: 2020, Dec / 2020, Nov /2021, Feb / 2021 , Jan
Is shown like this: 

brincos22_0-1612513066303.png

FYI: Ive created this column 

YearMonth = FORMAT([Created],"YYYY,MMM")
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You need to change your YearMonth definition to 

YearMonth = FORMAT([Created],"YYYYMM")

or introduce a "Sort By"  column that sorts by month number, not by month name.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

You need to change your YearMonth definition to 

YearMonth = FORMAT([Created],"YYYYMM")

or introduce a "Sort By"  column that sorts by month number, not by month name.

Anonymous
Not applicable

Thank you so much and sorry for this silly question! ๐Ÿ˜ฌ

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)