Forum Discussion
pal95
Helper III
6 years agoSetting days in a correct order
Hi, just a simple question: I would like days to be in the correct order on my axis, like Monday, Tuesday, Wednesday, etc. Please take a look at the images attached and you will understand what...
- 6 years ago
You need to use the Sort By Column feature for this. Please see this link. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You can use your DayOfWeek column to sort the day name column.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
amitchandak
Super User
6 years agopal95 ,
Add a column
week day = weekday([Date],2)
And sort you weekday name on this
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column