How to sort the week day names as Monday, Tuesday and Wednesday like this at week day drop down?

[d_sandip59]

Hi,

I have used the below DAX

WeekDay = format(Test[FIRST_TOUCH_DATE_TIME],"dddd")

and it gives me this:

Saturday, sunday, Monday i.e Week day names, but I nned to show the name in a sorted order like Monday, Tuesday, Wednesday..

Currently it is hown as below, so how can I achieve this?

[Zhengy]

This will create an error, " A circular dependency was detected". 

[Anonymous · Accepted solution]

Hi @d_sandip59

There is no direct option to sort week day, try to sort manually by the following way-

1. Create a calculated column and write the below DAXWeekDay Sort = SWITCH(Table1[WeekDay],"Monday",01,"Tuesday",02,"Wednesday",03,"Thursday",04,"Friday",05,"Saturday",06,"Sunday",07,08)
2. Sort "WeekDay Name" column by "WeekDay Sort" Column under the Modeling tab in ribbon palet.

For more details see the pbix file. Hope this will help you!!!

Download pbix file

[Anonymous]

Hi ,

I created a measure and done all the required things , in table the data is sorted but in visual (line graph) it is not sorted . Suggestions appreciated ..!

Thanks .

[saud968]

I have the below two measures I am not getting the sort option in modelling also, I using this in matrix visual.

DayText = SWITCH(support__cw_ops_manage_case_merge_temp[WeekDaySort], 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday", 7, "Sunday", "Unknown")

WeekDaySort = SWITCH(support__cw_ops_manage_case_merge_temp[Day], "Monday", 1, "Tuesday", 2, "Wednesday", 3, "Thursday", 4, "Friday", 5, "Saturday", 6, "Sunday", 7, 8)

[LivioLanzo]

hi @d_sandip59

Add a new column with the weekday number and then sort Weekday by WeekDay number in Table view

[Anonymous]

Hi LivioLanzo ,

I tried same as u said but i got an error <refer to img attached>

Please can u suggest anything ??

Thanks .

[saud968]

in the date table create a new column like this
and you need to pull it out onto the matrix instead of your column

[Anonymous]

Error :

[saud968]

use these - 

WeekDaySort = SWITCH(Day], "Monday", 1, "Tuesday", 2, "Wednesday", 3, "Thursday", 4, "Friday", 5, "Saturday", 6, "Sunday", 7, 8) and 

DayText = SWITCH([WeekDaySort], 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday", 7, "Sunday", "Unknown")

and then use the previously given dax

[Anonymous]

Thanks Dude .

[saud968]

You are welcome, glad to help.

[Anonymous]

Even if I try direct connection between week and weeknumber then I found the below error 

[saud968]

This is for sorting the column by week day name and not week number so the one I shared it will not work. 

[saud968]

Try this - 

Day Name_ = REPT(UNICHAR(8203),7-(Weekdaysortedcolumn)&(dayname)