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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
raj777karthik
Employee
Employee

Sort based on month year in line chart

i need to sort customers based on Month year asc.


For example in my line chart X axid it get sorted 01-18,01-19,01,20, 02-18,02-19,02-20 but my logic i have to sort like 01-18,02-18,03-18 and 01-19,02-19,03-19.

 I have used calculated column 

MonthYear date = FORMAT(Date[CreatedOn Date],"MM-YY")and this is text format as well.
Let me know how can i sort.Any helps appreciated
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@raj777karthik , Create one more column

MonthYear Sort= FORMAT(Date[CreatedOn Date],"YYMM")

 

Now click on your column, in column tool -> use sort column and choose this new column

 

Sort Month.png

 

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@raj777karthik , Create one more column

MonthYear Sort= FORMAT(Date[CreatedOn Date],"YYMM")

 

Now click on your column, in column tool -> use sort column and choose this new column

 

Sort Month.png

 

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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