cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
langer83 Frequent Visitor
Frequent Visitor

Sorting Day of Week Names according to Date Desc

I made a column based off of a date column ( DayName = FORMAT([date],"ddd" ) and cannot not get this graph to sort by Date Desc. I also have a column with the #day of the month that I can possibly use. I can only get the graph to sort alphabetically. Any help is appreciated.

 

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
langer83 Frequent Visitor
Frequent Visitor

Re: Sorting Day of Week Names according to Date Desc

I ended up creating a column with the week number and day name (1: Mon, 2: Tues, .... ). Ideally, I wanted the data for the weekdays groupings to go in the order of the last dates from the top graph such as starting with Thurs on the far right then Wed to the left of Thurs, then Tues,... on the second graph and working back 7 days.

 

graph.JPG

7 REPLIES 7
samdthompson Established Member
Established Member

Re: Sorting Day of Week Names according to Date Desc

i have struggled with this too and found the best way till its sorted by MS is to go day_of_week_number&") "&Day_name. that way its text but sorted by the number 

healthEteam Regular Visitor
Regular Visitor

Re: Sorting Day of Week Names according to Date Desc

Try going into the data section of your power bi desktop.

Highlight the column with the day names and then click on the Sort By Column.

 

Sort By Column.PNG

 

This will popup all of the columns in your dataset.... choose the column that has the day numbers.

Once you go back to your graphic it should be sorted properly.

Baskar Super Contributor
Super Contributor

Re: Sorting Day of Week Names according to Date Desc

Hi Langers , 

It too simple cool

 

1. U have to create week day, if u already have that is great , your prob solved :-)

 

Choose your week day and move to modeling ribbon.

there u can find the option sort by column see the below image.

 

is sorting order u could choose the Weekday. Thats it

 

 

 

Sort By Column.PNG

 

Let me know its not working for u.

Highlighted
langer83 Frequent Visitor
Frequent Visitor

Re: Sorting Day of Week Names according to Date Desc

I ended up creating a column with the week number and day name (1: Mon, 2: Tues, .... ). Ideally, I wanted the data for the weekdays groupings to go in the order of the last dates from the top graph such as starting with Thurs on the far right then Wed to the left of Thurs, then Tues,... on the second graph and working back 7 days.

 

graph.JPG

fherrera Frequent Visitor
Frequent Visitor

Re: Sorting Day of Week Names according to Date Desc

Thank you for the solution. It helped me alot.

Re: Sorting Day of Week Names according to Date Desc

I attempted this and is is still not working for me. 
The days are still sorted alphabetically. 

ShNBl84 Frequent Visitor
Frequent Visitor

Re: Sorting Day of Week Names according to Date Desc

Maybe you did the same thing I did. I have a column that is 1, 2, 3,... 7 and the other column is Mon, Tues, .... Sun. Highlight the Mon, Tues... column and then "Sort by Column" choosing the 1, 2, 3 column.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 35 members 1,070 guests
Please welcome our newest community members: