+ Reply to Thread
Results 1 to 2 of 2

Slicer buttons change positions in certain situations

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Slicer buttons change positions in certain situations

    My Week 1 slicer for Feb18 seems to function correctly. However, when I click the week 2 button, then the Mon button, the button for week 2 moves to the top (so that week 1 is now below it). The data and chart are correct for 2-5, but clicking the Tue button (which should be 2-6) doesn't change anything. Clicking the Wed button gives me the correct data for Tue.
    I've gone round and round on this, but my expertise at slicers is obviously sorely lacking - can someone tell me how this is screwed up?
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Slicer buttons change positions in certain situations

    Hi,

    Your pivot table doesn't appear to include all the relevant source data- it only goes down to row 169. Adjust that and refresh and the slicers seem to work properly. Regarding the order of the weeks, you should uncheck the option to show items with no data last in the Slicer settings.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Locate the 25 positions of the letters of the 4 blocks Each block has 25 positions
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 50
    Last Post: 12-22-2017, 12:46 PM
  2. Change categorie positions in pivot chart
    By jonas-martens in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-15-2017, 10:28 AM
  3. [SOLVED] Slicer buttons i don't want
    By wholesaleguy in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 11-21-2016, 11:44 AM
  4. How to use SUM on cells that change positions?
    By loccy in forum Excel General
    Replies: 3
    Last Post: 02-15-2016, 09:37 PM
  5. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  6. Lock everything but slicer buttons
    By svebbi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-04-2012, 12:04 PM
  7. How to change POSITIONS?
    By JDMiller in forum Excel General
    Replies: 3
    Last Post: 08-05-2008, 06:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1