Forum Discussion
Weeks group sorting
Hi all,
Appreciate hepl pointing in right direction.
I have blow matrix for each week - starting on Monday for multiple financial years (July to June).
How do I sort weeks Ascending to show most recent at the top?
I have tried week no. and formating which does give me sorting but then it only shows week-1, week-2 and not the actul week group with start and end date as above table
Hello VK_nz ,
please try the below steps to get the week sort column by calculated column and sort the week group by this column..
Step 1 - Create Week Sort Column and make sure you make the data type as whole number.
Step 2 - Sort the Week group column by "Week Sort" Column which you created.
Now you view the Week group sorted in the Visual..
There a much easier way to do in Power query but the above approch also works fine..
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
8 Replies
Hi VK_nz
Can you please share a pbix or some dummy data that keep the raw data structure with expected results, in your case just a calendar table? It should help us clarify your scenario and test to coding formula.
Thank you Rita, I have copied dropbox link for the calendar file. Appreciate your help.
While I have created week group with start date and end date of the week, I just cant get to sort it chronologically.
Hello VK_nz ,
please try the below steps to get the week sort column by calculated column and sort the week group by this column..
Step 1 - Create Week Sort Column and make sure you make the data type as whole number.
Step 2 - Sort the Week group column by "Week Sort" Column which you created.
Now you view the Week group sorted in the Visual..
There a much easier way to do in Power query but the above approch also works fine..
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
Found solution by adding
Week Start date = 'Calendar'[Date].[Date]+-1*WEEKDAY('Calendar'[Date].[Date],2)+1as sorting column to week grouptharunkumarRTK Thank you, exactly what i wanted.
tharunkumarRTK I got value for current week and want to plot previous week value side by side i.e. week 09/09 should have 78 in previous week column value :
