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
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
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.
Last edited by ptmuldoon; 01-30-2021 at 11:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks