Forum Discussion
sorting by column
hello,
I try to sort using "column sorting" on weekdays but this column sorting option doesn't make me the right sort to have Monday, Tuesday, 'Wednesday' 'Thursday' 'Friday' 'Saturday' 'Sunday' it sorts me Sunday Thursday Monday Friday' 'Saturday
have you an idea please
thank you🙂
You need a "Day of the Week" column in your date chart that is from 1 to 7 that corresponds to Sunday to Saturday, or From Monday to Sunday, or whatever you want it to be. Next, I would sort the "Day of the Week" by the "Day of the Week" column.
Next, you need to make sure that the visual is sorted by that. Often, a visual is sorted by default by the data themselves. CLick on the ellipses for the visual and sort area and make sure it is sorted by your day of the week. Otherwise, it will be apparently random if they are by the data values.
user83 , You can create Weekday with option 2
Week day =Weekday = WEEKDAY([Date],2)
Mark it as the sort column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
4 Replies
You need a "Day of the Week" column in your date chart that is from 1 to 7 that corresponds to Sunday to Saturday, or From Monday to Sunday, or whatever you want it to be. Next, I would sort the "Day of the Week" by the "Day of the Week" column.
Next, you need to make sure that the visual is sorted by that. Often, a visual is sorted by default by the data themselves. CLick on the ellipses for the visual and sort area and make sure it is sorted by your day of the week. Otherwise, it will be apparently random if they are by the data values.
thank you 🙂
user83 , You can create Weekday with option 2
Week day =Weekday = WEEKDAY([Date],2)
Mark it as the sort column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
thank you amitchandak
