BUG: PowerPivot 2012 Slicers are lost from PowerPivot Field List - by Chris - SQLBI

Status : 


Sign in
to vote
ID 755850 Comments
Status Active Workarounds
Type Bug Repros 2
Opened 7/27/2012 11:45:56 AM
Access Restriction Public


Slicers can be lost from the "Slicers Horizontal" and "Slicers Vertical" sections of the PowerPivot Field List in Excel.

Changing the values selected in the slicer often still updates the PivotTable / Chart though it is no longer possible to manage the slicers using the PowerPivot Field List.

The attached files are a full repro for the issue, including video.  The Model.xlsx file is the broken one (i.e. that results from following the steps shown in the video).  The Model_working.xlsx file is the one that is used from the start of the video (i.e. before the issue occurs).

I have managed to replicate this issue on the PP2012 CU2 update.
Sign in to post a comment.
Posted by nexusstone on 11/24/2012 at 4:40 AM
Please also see comments / issues posted re this 'disappearing slicer' issue in May, 2012...


To repeat, the only (very PAINFUL) 'solution' that I have found to deal with this problem -- is RECREATE (from SCRATCH) the PP PTs... Even then, sooner or later, MOST PP PTs seem to have the SAME problem (i.e., disappearing slicers)...

james m birney
Posted by Kasper [MSFT] on 9/27/2012 at 1:57 PM
HI Chris,

Thank you for filling the bug. We will investigate.

Kasper de Jonge
Analysis services team
Posted by Chris - SQLBI on 7/27/2012 at 11:49 AM
PS... I have hit this issue numerous times before now without understanding the full causes. If you have a workbook that you use regularly, it is common to open it and immediately enter the PowerPivot window to perform a refresh without clicking on any of the PivotTables / Charts.