Week starts from today date (First day of the week will be the today date)

[Anonymous]

Need some help.
I want to sort the days in the chart (from right to left) for last 7 days but the first day of the week will be current day.
In the below screenshot friday is my current day. (this is how i want to sort as shown in the screenshot below).

So , if  my current day is "Monday" then the sorting will look like (right to left). (monday to tuesday)

        tue     wed      thu      Fri       Sat      Sun      Mon

How can i achieve this please help !!!

[Aburar_123 · Accepted solution]

Hi @Anonymous ,

Table:-

Date_Dim = CALENDARAUTO(12)

Calculated Columns:-

Day Number = WEEKDAY('Date_Dim'[Date],2)

Week Day = FORMAT(Date_Dim[Date],"DDD")

Sort_Order =

var _curr_day = WEEKDAY(TODAY(),2)-'Date_Dim'[Day Number]

var a = WEEKDAY(TODAY(),2)+abs(WEEKDAY(TODAY(),2)-'Date_Dim'[Day Number])

return if(WEEKDAY(TODAY(),2)>='Date_Dim'[Day Number],_curr_day+1,a)

and sort the "Week Day" column by Sort_Order column then use the "Week Day" column in the X-Axis.

it will start from today date from right

Please accept it as a solution if it solves your problem. Thanks!

[Aburar_123]

Hi @Anonymous ,

You can achieve it as below,

Date Dim = CALENDARAUTO(12)

Day Number = WEEKDAY('Date Dim'[Date],2)

Expected_day_number =

var _curr_day = WEEKDAY(TODAY(),2)-'Date Dim'[Day Number]

var a = WEEKDAY(TODAY(),2)+abs(WEEKDAY(TODAY(),2)-'Date Dim'[Day Number])

return if(WEEKDAY(TODAY(),2)>='Date Dim'[Day Number],_curr_day+1,a)

[Dinesh_Suranga]

@Anonymous 

Hi

Do you have a calendar table?

If yes add a new column with first three letter of the day. Ex. Sun Mon.

Then filter date to top 7 days in the visual filters. Then order by descending.

Thank you.

[Anonymous]

I have tried this before but it is not working. 

[Dinesh_Suranga]

@Anonymous ,

1 Add a new table with latest 7 days of calender.

2 Add Day column

3 Sort Day column by Date column

4 Create relationship between calander table date column and new table date column.

5 Use new table Day column to visual.

Thank you