Hello World,
I have a column called PaymentDate.
I then created a new column called Weekday this way. Weekday = FORMAT(Final[PaymentDate ],"DDDD")
I created a visualization. But the weekday is not showing in chronological order. I sorted by weekdays but didn't work. How do I arrange in chronological order: Weekday starts from Sunday (US weekday). I want the visual weekday to be displayed as sun, mon, tues, wed, thurs, fri and sat.
@Anonymous Use the WEEKDAY function and set it as a Sort By column.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Anonymous Use the WEEKDAY function and set it as a Sort By column.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Greg_Deckler It's giving me Saturday as 1 . I want the weekday to start from sunday. How to fix it?
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
