Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11473
  • Last Modified:

How to remove blanks from slicers - Excel 2010 -

I've created a pivot table and added some slicers on it, one of them is showing "blank" in it, however I checked my data and made sure not blank cell is in that column. How can I remove it ?
0
LubinofS
Asked:
LubinofS
  • 2
1 Solution
 
nutschCommented:
Try, in order of pain:
- refreshing the pivot
- changing the data source (to the same as it was)
- rebuilding the pivot with your blank-less data

Thomas
0
 
LubinofSAuthor Commented:
Nahh...I spent big time building the pivot table and calculations...never had blank data on it.
0
 
LubinofSAuthor Commented:
Would affect it the fact that I got blank data in other columns that dont have slicer ?
0
 
Jerry PaladinoCommented:
Check the data source range.  It is possible it may extend below your actual data and that will cause a blank to show in the pivot values.

To cross check, add the field in question to a "Report Filter" field and drop down the list of values.  You will also see the blank value there as well.   Think of a slicer as a visual representation of a Report Filter field.

Blank values in other fields will not effect the values show in a slicer.

HTH
Jerry
1

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now