Forum Discussion

VK_nz's avatar
VK_nz
Icon for Helper I rankHelper I
2 years ago
Solved

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 mos...
Need Help
Tips and Tricks
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    VK_nz 

    You can follow this approach:

     

     

     

    I am attaching the PBIX file below

    Need a Power BI Consultation? Hire me on Upwork

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!

     

     

  • dharmendars007's avatar
    dharmendars007
    2 years ago

    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

    LinkedIN 

     

VK_nz's avatar
VK_nz
Icon for Helper I rankHelper I
2 years ago

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.

dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
2 years ago

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

LinkedIN