Solved

How to remove blanks from slicers - Excel 2010 -

Posted on 2014-03-14
4
9,770 Views
Last Modified: 2014-06-04
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
Comment
Question by:LubinofS
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39929847
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
 

Author Comment

by:LubinofS
ID: 39929908
Nahh...I spent big time building the pivot table and calculations...never had blank data on it.
0
 

Author Comment

by:LubinofS
ID: 39930345
Would affect it the fact that I got blank data in other columns that dont have slicer ?
0
 
LVL 16

Expert Comment

by:Jerry Paladino
ID: 39931180
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
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now