Reply
Syndicate_Admin
Administrator
Administrator
Syndicated - Inbound

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

Dani_Snchez_0-1680633118308.png

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Syndicate_Admin ,

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

vyiruanmsft_0-1680853404779.png

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

vyiruanmsft_1-1680853548102.png

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

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)