Forum Discussion
WeekDay Sort on Column chart
- 5 years ago
Anonymous , if you have date in table create a sort column
Weekday = weekday([date])
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
else create
- 5 years ago
Anonymous , Then refer to my second option
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
Anonymous , if you have date in table create a sort column
Weekday = weekday([date])
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
else create
- Anonymous5 years agoNot applicable
amitchandak - I do not have a date column. I only have 2 columns weekday & value.