
Arun Kumar
Member
Members

Forum Posts: 12
Member Since:
April 5, 2018
April 5, 2018

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

Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 870
Member Since:
December 7, 2016
December 7, 2016

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Genevieve Guex, Richard Benson-King, Janset Beyaz
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
wahab tunde
Cong Le Duc
Faisal Bashir
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Len Matthews
Kristine Arthy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6205
Posts: 27209
Member Stats:
Guest Posters: 49
Members: 31878
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
