Counting Rows By Week?

[pe2950]

I'm having an issue counting rows by week...

I have two tables: Appointments, DateKey

• Appointments
  • Each row has a [Counter] = 1
  • Each row has a  [CreateDate] = Date Row Created
• DateKey
  • [Date] column containing all the dates
  • [Year-Week] column calculated as Year-Week = YEAR(DateKey[Date])&"-"&WEEKNUM(DateKey[Date])
  • [WeekNum] column calculated as WeekNum = WEEKNUM([Date])
• Relationship
  • 1 DateKey[Date] - * Appointments[CreateDate], Crossfilter both

Trying to create a barchart with the weeks on the axis and the sum of appointments[count] as the value. It seems like its sorting it by the count from largest to smallest, instead of using the weeks to sort it by time. The DateKey table is marked as a Date Table with [Date] set. 

[parry2k]

@pe2950 click on top right corner (3 dots) and in there choose the sort order and sort by column