Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
1,108
Views
Topic starter
Hi,
In our financial system, month is represented by number and started with period 7 (July) and end with Period 6 (June). I have downloaded transactions listing and added to data model along with the following table of period name.
| Period | Month |
| 7 | July |
| 8 | August |
| 9 | September |
| 10 | October |
| 11 | November |
| 12 | December |
| 1 | January |
| 2 | February |
| 3 | March |
| 4 | April |
| 5 | May |
| 6 | June |
I have created a relationship between two tables via Period column. When I create a slicer from period table, it is sorted in alphabetical order instead desired order. Like below.
| Slicer | Desired Slicer | |
| April | July | |
| August | August | |
| December | September | |
| February | October | |
| January | November | |
| July | December | |
| June | January | |
| March | February | |
| May | March | |
| November | April | |
| October | May | |
| September | June |
How to get desired order in slicer? Please help
Kind Regards
Arun
Posted : 07/07/2018 4:48 am
Hello,
Check this article, if you scroll down a little you will find a tip on how to sort the months name in fiscal sort order.
Br,
Anders
Posted : 07/07/2018 5:27 pm