Forum Discussion
Week range column not in order on Matrix Visual
Good day I currently have a Matrix visual with the flowing drill down Rows Campaign Date Month WeekRange Status The drill down feature works however when I get to the week range the o...
Thank you for trying to assist.Screen shot above.Highlite in red show the order of weekrange gets distorted when I drill down to week range level.I have even tried adding a weeknumber column WeekNumber = WEEKNUM('Calander'[Date]) but that does not work either.
Kind regards
Hi IGOTPOWER,
The order of week range in the visual according to the first number by default, like 05->12->19->26->29. You don'e need to change your date format. Please click your [week range] field, plase sort by Date column as follows, and check if it works fine.
Best Regards,
Angelia