- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Annual evolution by days
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-17-2025 02:51 PM | |||
01-06-2025 08:11 AM | |||
08-09-2023 03:13 AM | |||
10-17-2024 06:15 AM | |||
08-04-2024 12:19 AM |
User | Count |
---|---|
136 | |
107 | |
86 | |
58 | |
46 |