Re: Sorting of Week in DateDim with several years

Anonymous · ‎04-23-2019

Hi!

I have an date dimension with rows worth of several years. My users would like to have an date hierarchy from Year to Week, but I have challenges sorting my Week numbers having them in the order of several years.

Error now occurs in an line chart.

parry2k · ‎04-23-2019

@Anonymous how you are showing week numbers? You should include year in week number column and that will take care of it.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎04-23-2019

Hi @parry2k . Like this

v-yuta-msft · ‎04-23-2019

@Anonymous ,

I'm afraud you need to create an additional "WeekNum" column manually because dax can't generate the WeekNum automatically by date.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k · ‎04-23-2019

@Anonymous i think you need to sort value in visual, click top right corner (3 dots) on visual and make sure sort is by week and it is a to z.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎04-23-2019

Still doesn't work.. The formula I used is:

Weeknum = YEAR([date]) & format(WEEKNUM ( [Date] );"00")

It's currently default sorted.

v-yuta-msft · ‎05-08-2019

@Anonymous ,

Format() function will return text, not number, change the weeknum from text to number and check if it can work.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sorting of Week in DateDim with several years

Helpful resources

Fabric Data Days

Power BI Monthly Update - October 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

Fabric Data Days starts November 4th!