Setting days in a correct order

[pal95]

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 I mean.

Thank you for your time!

[amitchandak]

@pal95 ,

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

[Anonymous]

First Createa new calculated column for Day of week 

Second, sort your [Day] column by your newly created [Day of Week] column.

Highlight the [Day] column

Click Modeling -> Click Sort By Column -> click [Day of Week]

[mahoneypat · Accepted solution]

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