Forum Discussion
Problem with sorting month names in calender table
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
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
Hi FrankWe
The benefits of lookup table is if your fiscal month start from July and end in June, you should update only the SortOrder column in lookup table
Please see the exampleMonth MonthSort January 7 February 8 March 9 April 10 May 11 June 12 July 1 August 2 September 3 October 4 November 5 December 6 If your requirement is solved, please make CORRECT ANSWER a SOLUTION
No, that has nothing to do with the fiscal year. The visuals must show a time period of the last three or six month as an example. The fiscal year is not changed, it is from January to December.
Frank
Hi FrankWe
Please share sample pbix file link (allow access to all) and show expected result in screenshot
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523