Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
gbarr12345
Post Prodigy
Post Prodigy

How to make the month in order

‎10-21-2024 04:13 PM

Hi there,

 

I have a table visualisation in power bi and when I pull in the month name, they're not in order like June, July, August, etc.

 

gbarr12345_0-1729552456839.png

 

 

The format is text but I'm wondering how do I make the in order?

 

gbarr12345_1-1729552396234.png

 

This comes from a calculated table for a calendar table so I'm wondering is this the reason why?

 

CalendarTable =
ADDCOLUMNS(
    CALENDAR(DATE(2024, 7, 1), DATE(2025, 6, 30)),
    "Dates", FORMAT([Date], "DD/MM/YYYY"),
    "Year", YEAR([Date]),
    "Month", FORMAT([Date], "mmmm"),
    "Quarter", FORMAT([Date], "\QQ"),
    "Month Year", FORMAT([Date], "mmm yyyy"),
    "Day", DAY([Date]),
    "Month Number", MONTH([Date]),
    "Week Number",
        INT(DATEDIFF(DATE(2024, 7, 1), [Date], DAY) / 7) + 1
)
 
Any help would be much appreciated!

 

 

Labels:
Message 1 of 3
313 Views
0
1 ACCEPTED SOLUTION
KNP
Super User
Super User

‎10-21-2024 04:24 PM

You need to set the sort order of that column.

See below...

 

KNP_0-1729553058524.png

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image		fabric-SUbadge
Proud to be a Super User!

View solution in original post

Message 2 of 3
292 Views
2 REPLIES 2
KNP
Super User
Super User

‎10-21-2024 04:24 PM

You need to set the sort order of that column.

See below...

 

KNP_0-1729553058524.png

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image		fabric-SUbadge
Proud to be a Super User!
Message 2 of 3
293 Views
gbarr12345
Post Prodigy
Post Prodigy
In response to KNP

‎10-21-2024 05:03 PM

That worked, thank you so much!

Message 3 of 3
263 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All