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 

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

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.

How to Get Your Question Answered Quickly  

  • 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