+ Reply to Thread
Results 1 to 2 of 2

Exclude data from Slicers?

  1. #1
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Exclude data from Slicers?

    Is it possible to exclude data from a slicer?

    An Example would be I have a Years column with years of 2000, 2001, 2002......... out to 2020.

    But I only want the slicer to show just the last 3 years?

    Is that possible?

    Thanks,
    PT

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: Exclude data from Slicers?

    I'm struggling in trying to see if this is possible.

    I have table (data model) that has several years of data. but I only want the slicer to show the Last 12 or Last XX months of data. I've tried creating a 2nd table of just the last XX months and creating a relationship in power pivot, but then I get (blank) showing up in the slicer for those values I left out.

    My only 'solution' is to abandon the pivot table all together, and work with CubeValues linked to the slicer values.

    Attached is a little sample. It has 11 months of 2020 data. But I want the slicer to only show the last 6 months.
    Attached Files Attached Files
    Last edited by ptmuldoon; 01-30-2021 at 11:00 AM.

+ 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. Slicers with same data problem
    By b20 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2020, 06:14 PM
  2. Exclude items from chart slicers (even if they have data)
    By chicagolarsons in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-01-2019, 01:24 PM
  3. [SOLVED] one slicers to filter data
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2018, 01:27 PM
  4. VBA to connect two slicers from two different data/cache.
    By expeo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2018, 01:07 PM
  5. [SOLVED] how to calcuate data (simple divsion)BUT data changes w/ slicers
    By eeps24 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2017, 04:11 PM
  6. Synchronising slicers with different source data
    By burger160 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2016, 07:26 PM
  7. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM

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