How do I sort by workweek in Power BI Desktop?

[ryuuden2605]

Hi,
I'm trying to create a report to show the number of survey respondents and CSAT per week. However, the weeks are not showing in correct order. Instead of being in 1,2,3,4,5... order, it's showing as 1,10,11,12,13,14,15,16,17,18,19,2,20... Can you give me a tip on how to fix this? Thanks in advance! 🙂

[AlexGorev]

Try using Sort By feature described here: https://support.powerbi.com/knowledgebase/articles/592116-sort-by-column-in-power-bi-desktop

Alex.

[mllopis · Accepted solution]

Could you make sure that the field is of type number? You can select the field in the Fields pane and look at the type in the Data Tools - Modeling tab in the ribbon.

[Tsanka]

One possible option is:

Week = Format (WEEKNUM([Date]);"00")