Forum Discussion
pal95
Helper III
Helper IIISetting 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...
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
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]