Forum Discussion

ThisIsIt's avatar
ThisIsIt
Frequent Visitor
6 years ago

Weekday Sort by Date

Hello Everyone!  Hoping you can help.   I have a column I created that gets the Day of Week from a Date.  I'd like to sort that Day of Week in my visual by date from oldest to newest and not by wee...
Need Help
ThisIsIt's avatar
ThisIsIt
Frequent Visitor
6 years ago

Unless I'm missing what you are saying, I'm actually trying to sort by Date and not Number.  I have my visual set for a relative date of 1 week.  I'd like to have the most recent date to the right and the oldest to the left, but displayed by WeekDay instead of date.  I tried selecting the WeekDay column and changing the sort by from the modeling tab but it threw an error (see below).

 

These should be reversed if sorted correctly by Date as opposed to WeekDay Name

 

 

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
6 years ago

Hi  ThisIsIt ,

 

according to my understanding, JarroVGIT suggestion is right.

First on power query, arrange your date in ascending order or descending order

Then have an index column that corresponds to your Weekname.

Then on Modeling tab, you can use the sort the week by the index column you made.

or

 

Simply have a date table.