Forum Discussion

Uzi2019's avatar
Uzi2019
Community Champion
3 years ago

Sort week column by multiple values in date

Hi Expert, I have Date, Start Week, End Week, and Week columns. I want to sort my week column based on date or start week column but because of multiple values in date column I cant sort it.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Uzi2019 ,

Try below steps

 

To sort the Week column in Power BI based on multiple values in the Date column, you can follow these steps:

  1. Select the Week column in your table visualization.
  2. In the "Modeling" tab of the Power BI ribbon, click on the "Sort by Column" button.
  3. In the dialog box that appears, select the Date column from the drop-down list.
  4. Click OK to apply the sort.

By specifying the Date column as the sort column for the Week column, Power BI will use the values in the Date column to determine the sorting order of the Week column. This way, your Week column will be sorted based on the corresponding dates.