Solved

How to remove blanks from slicers - Excel 2010 -

Posted on 2014-03-14
4
10,344 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
1

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel formula to report date modified 14 29
Add Attendee Macro need not halt for Acknowledgement 12 25
Need conditional formating when doubles 14 21
Excel Macro 9 22
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

821 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