Annual evolution by days

[Syndicate_Admin]

Good afternoon

I am trying to create an evolutionary (a graph of lines) annual by days, for this using the example that comes in the Power BI desktop of Financial, I create a calendar and through the formulas of time intelligence once I have the day and the month I concate them and I order the column by the numerical column of the day and the month, but when I try to order it is not ordered correctly because days 1 and 2 interprets them as 10 and 20 and if I ask you to give it to me in 2-number format it tells me that day 1 is 31, I attach several screenshots, to see if someone else has happened and can help me, Thanks a lot

[v-yiruan-msft]

Hi @Syndicate_Admin ,

If I understand correctly, the problem is the calculated column [Orden Dia-Mes] can't be sorted correctly. Am I right? 

But when I applied the similar formula, it seems OK. Please check the below screenshot.

Could you please provide some sample data in your calendar data and your final expected result with the specific examples? Thank you.

Best Regards