My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Slicers - Number Order|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Slicers - Number Order|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Slicers - Number Order
Avatar
Paul Benjamin
Member
Members
Level 0
Forum Posts: 84
Member Since:
July 11, 2017
sp_UserOfflineSmall Offline
1
February 8, 2018 - 9:14 pm
sp_Permalink sp_Print

I have a slicer on a dashboard that is from W1 to W52

But the order it appears in is it groups all weeks that start with W1, i.e W1,W10,W11,,W12 etc then W2,W20,W21,W22 etc

Is it possible to have the slicer be in W number order from W1 through W52

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
2
February 8, 2018 - 9:44 pm
sp_Permalink sp_Print sp_EditHistory

Hi Paul

If possible change your source data from W1 W2 etc to W01 W02 and so on.

Sunny

Avatar
clark shao
Member
Members
Level 0
Forum Posts: 44
Member Since:
November 19, 2017
sp_UserOfflineSmall Offline
3
February 9, 2018 - 10:34 am
sp_Permalink sp_Print

extract numbers first and then select column A:C, sort column B or column C in an ascending order.

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
4
February 9, 2018 - 11:34 am
sp_Permalink sp_Print

Hi Paul

If you are unable to change your source data then maybe you can consider using a custom list to sort the Slicer.

Sunny

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: David Jernigan, Louis Muti
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
Forum Stats:
Groups: 3
Forums: 24
Topics: 6359
Posts: 27806

 

Member Stats:
Guest Posters: 49
Members: 32336
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen