Sorting a graph

[MaryEliz21]

I have a set of data that reads latest weeks end 1/21/24, latest 4 weeks ending 1/21/24, latest 13 weeks ending 1/21/24 for multiple brands. The date will change every week. How do I get my graph to sort these in the correct order? It wants to put all the latest 4 together, latest 13 together, etc.

Thank  you!!!!

[Ashish_Mathur]

Hi,

See if my solution in the attached file helps.

[Anonymous]

Hi @MaryEliz21 ,

Not quite sure what your intentions are. But you can refer to the following schedule:

DimDate = 
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "MMMM" ),
    "MonthSort", MONTH ( [Date] ),
    "Day", DAY ( [Date] ),
    "DayName", FORMAT ( [Date], "DDDD" ),
    "WeekDay", WEEKDAY ( [Date],2 ),
    "WeekStart",[Date] - WEEKDAY ( [Date], 2 ) + 1,
    "WeekSort",WEEKNUM([Date],1)
)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[MaryEliz21]

See in the below screen shot the weeks at the bottom of the chart. I need to get the dates in order, while keeping the 4 weeks in front of the dates. 

[Anonymous]

Hi @MaryEliz21 ,

Create the appropriate date table and pass the sort by column

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.