Forum Discussion
FrankWe
Helper II
Helper IIProblem 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...
PijushRoy
Community Champion
Community ChampionHi FrankWe
Please create a lookup table by enter data for MONTH SORT
| Month | MonthSort |
| January | 1 |
| February | 2 |
| March | 3 |
| April | 4 |
| May | 5 |
| June | 6 |
| July | 7 |
| August | 8 |
| September | 9 |
| October | 10 |
| November | 11 |
| December | 12 |
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
FrankWeHelper II
Helper IIHi Pijush,
I have the same info (MonthNumber) in my calender table, too. But I will try and let you know.
Frank