Notifications
Clear all
Power Pivot
3
Posts
2
Users
0
Reactions
90
Views
Topic starter
Hi
I have added a 'Weeks' slicer onto a pivot table chart but it does not show in 1 to 52 order? it shows as W1, W10, W11 etc.
How can format the slicer to show in 1 to 52 order?
Thanks
Paul
Posted : 02/11/2017 12:00 pm
Hi Paul,
You need to use the 'Sort by' setting as shown in session 4.05 of the Power Pivot course. You may need to add a column that contains a numeric week numbers i.e. 1,2,3... and use this to sort your text based week numbers: W1,W2,W3...
Mynda
Posted : 02/11/2017 7:15 pm
Topic starter
Thanks Mynda
Posted : 03/11/2017 7:07 am
