Forum Discussion

IGOTPOWER's avatar
IGOTPOWER
Frequent Visitor
9 years ago

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...
Need Help
IGOTPOWER's avatar
IGOTPOWER
Frequent Visitor
9 years ago

 

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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi IGOTPOWER,

After check and test, the Jan 29 - Feb 04 is the same weeknumber, and it shows correctly. What's your problem? Why the order of weekrange gets distorted?



Best Regards,
Angelia

  • IGOTPOWER's avatar
    IGOTPOWER
    Frequent Visitor
    9 years ago

     

    Hi I think that I am having an issues were the order of the weekrange is followjng the order of the day that the week range starts with.Ex 29 Jan-04 Feb comes through at the end of the drilldown.Do you think I should perhaps change the format of my dates ?

     

    Thanks again for the help