Dax Sorting weekday in Chronological order

[Sami95]

Hello World,

I have created a visualization where I sort the axis by weekday. But it is not giving me the weekday in chronological order. How do I fix this. I want the starting day of the week from Sunday (USA weekday).

[v-jayw-msft · Accepted solution]

Hi @Sami95 ,

Create columns like below:

t_weekdays = WEEKDAY('Table'[date],1)

t_day = FORMAT('Table'[Date], "dddd")

Put t_day in x-asix field, t_weekdays in tooltips field.

Then sort the visual by tooltips column.

Best Regards,

Jay

[Jihwan_Kim]

Hi,

In the calendar table, try to create a new column for the sorting purpose. like the attached pbix file.

And then, click Weekday column -> sort by Weekday sort CC.

Please check the attached pbix file.

Weekday sort CC = 
WEEKDAY([Date],1)

[Sami95]

I have a column "Day". I created a new column. But it's giving me an error

Calendar =

ADDCOLUMNS (

    CALENDAR ( DATE ( 2022, 1, 1 ), DATE ( 2022, 12, 31 ) ),

    "Weekday", FORMAT ( [Date], "dddd" )

)

[tamerj1]

Hi @Sami95 
Please try new column then use it a sort by column

Weekday Number =
WEEKDAY ( 'Calendar'[Date], 1 )