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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dustdaniel
Helper II
Helper II

Sorting string date dd-mmm in line chart

Hi Everyone,

 

Could you guide me on what is the correct function to sort properly this string date dd-mmm in my line chart

 

dustdaniel_0-1726864048145.png

The date goes like this:

Calendar date dd-MMM = FORMAT(DateTable2[Date], "dd-MMM")

And the sort colum goes like this:

Sort dd-mmm = DAY(DateTable2[Date]) & MONTH(DateTable2[Date])

 

My result is obviously not correct:

dustdaniel_1-1726864250819.png

 

1 ACCEPTED SOLUTION
marcelsmaglhaes
Super User
Super User

Hey @dustdaniel 

Keep the dd-MMM format for display, and then create a proper sorting column using the numeric value of the month and day like this:

SortColumn = MONTH(DateTable2[Date]) * 100 + DAY(DateTable2[Date])

This ensures that January 1st (0101) comes before February 1st (0201), and so on.

Don't forget to set the Sort by column in your data model to sort Calendar date dd-MMM by SortColumn.


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



View solution in original post

4 REPLIES 4
marcelsmaglhaes
Super User
Super User

Hey @dustdaniel 

Keep the dd-MMM format for display, and then create a proper sorting column using the numeric value of the month and day like this:

SortColumn = MONTH(DateTable2[Date]) * 100 + DAY(DateTable2[Date])

This ensures that January 1st (0101) comes before February 1st (0201), and so on.

Don't forget to set the Sort by column in your data model to sort Calendar date dd-MMM by SortColumn.


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



Thank you very much Marcel,

 

It's working propperly. I have an additional question. 

 

When I have a Line chart with only one continuous line, it is available the option X-axis / Type: contonuous but this is not available then there are multiple lines. Is there a tourn around for that?

dustdaniel_0-1726866627655.png

 

Ensure that your x-axis data is numerical or date/time...

marcelsmaglhaes_0-1726867092155.png

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



Thanks. That makes sence!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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