sorting by column

[user83]

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🙂 

[edhans · Accepted solution]

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.

[amitchandak · Accepted solution]

@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

[user83]

thank you @amitchandak 

[edhans · Accepted solution]

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]

thank you 🙂