Hi,
I need help.!
i have a date clolum and Weeknum type as below.
the problem is when i use the column in the visual graph, the order of week is not what i want.
currenly it looks 2018 1 , 2018 11, 201812, 2018 2, . . . . 2018 9. ..
I want it to be 2018 1, 2018 2, 2018 3 , . . . . 2018 10, 2018 11, 2019 12
Is there any idea?
thank you,
CL
Hello @Anonymous
Add a column to your table like so.
WeekSort = YEAR('Calendar'[Date])*100 + WEEKNUM('Calendar'[Date],2)
Then select the [Week] column and set the Sort by column to [WeekSort]
Hello @Anonymous
Add a column to your table like so.
WeekSort = YEAR('Calendar'[Date])*100 + WEEKNUM('Calendar'[Date],2)
Then select the [Week] column and set the Sort by column to [WeekSort]
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
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.
