Forum Discussion

FrankWe's avatar
FrankWe
Helper II
2 years ago

Problem with sorting month names in calender table

Hello all,   I have a problem with sorting in calender table. I have a visual that shows the name of the month on the X-axis. To sort this correctly I selected the column "Month" and let this colum...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi FrankWe 

Please create a lookup table by enter data for MONTH SORT

MonthMonthSort
January1
February2
March3
April4
May5
June6
July7
August8
September9
October10
November11
December12


In this table month should be Sort By "MonthSort" column

Create a relationship with your fact table with "Month" column
Use "Month" from Lookup table in visual

Let me know if that works for you


If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

  • FrankWe's avatar
    FrankWe
    Helper II
    2 years ago

    Hi Pijush, 

     

    I have the same info (MonthNumber) in my calender table, too. But I will try and let you know. 

     

    Frank

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      FrankWe 

      In Calendar table, if you can use the MonthOrder as SortBy it will work but 
      Separate lookup table with sort by helps.

      Please check and let me know

      If your requirement is solved, please make CORRECT ANSWER a SOLUTION

      • FrankWe's avatar
        FrankWe
        Helper II
        2 years ago

        And how will the month order look like when I have a visual that should show the last three months? I need to have the following order:      Nov - Dec- Jan 

        If I use only the MonthNumber I think I will get:        Jan - Nov - Dec

        🤔

         

        Frank