Forum Discussion
sorting by column
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
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 🙂