Forum Discussion

Vinod_G_245's avatar
Vinod_G_245
Icon for Helper I rankHelper I
3 years ago

Sorting weeknumbers (year)

Hi Team,   I want to show data on weekly basis  for entire year. im not able to create sort column for Weeknumber. Thanks in advance.  
Need Help
Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi Vinod_G_245 

 

when creating your weeknumber column please use the following formula in power query.

 

"KW" & Text.PadStart(Number.ToText([WeekNumOfYear]),2,"0")

 

then it should sort correctly.

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

 

 

 

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Vinod_G_245 

 

Please on top tell Power BI in the visual to sort ascending by the week and not by the value

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.