Forum

Notifications
Clear all

Slicers - Number Order

4 Posts
3 Users
0 Reactions
70 Views
(@benjamip)
Posts: 89
Estimable Member
Topic starter
 

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

 
Posted : 09/02/2018 7:14 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Paul

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

Sunny

 
Posted : 09/02/2018 7:44 am
(@shaowu459)
Posts: 44
Eminent Member
 

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

 
Posted : 09/02/2018 8:34 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 09/02/2018 9:34 pm
Share: