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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!