Forum Discussion

VPonnarath's avatar
VPonnarath
Frequent Visitor
7 years ago
Solved

Sorting week is not working

Hello,   I have created a calculated column for the "Week Name-Month" in my date table which display the Month and the week number of the particular month.    Week Name-Month = CONCATENATE('Date'...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    VPonnarath,

    Please update your formula to the following, then change data type of week sort column to whole number.

    Week Sort Column = CONCATENATE('Date'[Calendar Month Number],'Date'[Week Number of Month])



    This way, when you sort Week Name-Month column by Week Sort Column, you will get expected sort.



    Regards,
    Lydia

     

parry2k's avatar
parry2k
Super User
7 years ago

VPonnarath you are on right track to using "sort by"

 

What is your fiscal month? Is it "Month name" or "Month Number"? Can you share screen shot how your week and sort column looks like?

VPonnarath's avatar
VPonnarath
Frequent Visitor
7 years ago

Thank you for your response ! 

 

See the below screen shot. I am trying to sor the "Week Name -Month " Cloumn with "Week Number of Month" Column. 

 

In my Line chart when I use Week Name -Month on Axis, It is not dispaying in an order

 

Line Chart- See the week order displaying

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    i think your sort column should be

     

    MM-Week Number of Month, like 

     

    01-01

    01-02

    01-03

    ...

    12-01

    12-02

    12-03

     

    And use this new field to sort your "Week Name-Month" field

     

    • VPonnarath's avatar
      VPonnarath
      Frequent Visitor
      7 years ago

      BRILLIANT !! 

       

      That worked like a charm.  Thank you so much  !! :)

    • VPonnarath's avatar
      VPonnarath
      Frequent Visitor
      7 years ago

      Hello, Actually, that didnt work. :)

       

      When i was testing with my sample data, it was working for me. But, when we uploaded the real data for whole year, the week name is not sorting in an order. 

       

      Can you please give me another solution for this?

       

       

      Thanks, 

       

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        ok so what is the issue. I guess you need to add more value in sort column but if you provide more details it will be helpful to resolve the issue.

         

        thanks,

        p