cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IGOTPOWER
Frequent Visitor

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

 

 

 

 

 

5 REPLIES 5
v-huizhn-msft
Microsoft
Microsoft

Hi @IGOTPOWER,

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

1.PNG

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

Best Regards,
Angelia

Capture.PNG

 

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.


1.PNG

Best Regards,
Angelia

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?

1.PNG

Best Regards,
Angelia

 

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

 

 

Capture.PNG

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.