Forum Discussion
Solved
How do I sort by workweek in Power BI Desktop?
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! :)
- 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.
3 Replies
One possible option is:
Week = Format (WEEKNUM([Date]);"00")
- 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.
Try using Sort By feature described here: https://support.powerbi.com/knowledgebase/articles/592116-sort-by-column-in-power-bi-desktop
Alex.
