Notifications
Clear all
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
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
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
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