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 order of the week range is distorted.The formulae I use for the weekrange is a follows

WeekRange = FORMAT(LOOKUPVALUE(Calander[Date],Calander[Day],1,Calander[WeekNumber],Calander[WeekNumber]),"DD MMM") & "-"& FORMAT(LOOKUPVALUE(Calander[Date],Calander[Day],7,Calander[WeekNumber],Calander[WeekNumber]),"DD MMM")

 

Thanks in advance

 

 

 

 

 

Need Help

5 Replies

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

    Hi IGOTPOWER,

    I create a calculated column using your formula, and add it in Matrix visual, it shows correctly as follows.



    So I can't reproduce your scenario(the week range is distorted), could you please share a screenshot for further analysis?

    Best Regards,
    Angelia

    • 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