Slicer not updating when source data is updated

%3CLINGO-SUB%20id%3D%22lingo-sub-3527859%22%20slang%3D%22en-US%22%3ESlicer%20not%20updating%20when%20source%20data%20is%20updated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3527859%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20dashboard%20showing%20project%20data%20with%20multiple%20pivot%20tables.%20There%20are%20two%20slicers%20that%20are%20connected%20to%20all%20the%20pivot%20tables%2C%20Project%20ID%20and%20Project%20Status%2C%20these%20used%20to%20update%20when%20the%20source%20data%20changed%20but%20this%20is%20no%20longer%20the%20case%20and%20still%20doesn't%20update%20after%20refreshing%20the%20data.%20E.g.%20The%20Project%20Status%20of%20Project%20LIB682%20changed%20from%20Active%20to%20Closed%20in%20the%20source%20data%2C%20however%2C%20if%20I%20select%20'Active'%20in%20the%20Project%20Status%20slicer%2C%20LIB682%20still%20appears%20in%20the%20ID%20slicer%20where%20it%20used%20to%20be%20greyed%20out%20to%20show%20it%20is%20not%20active.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20refreshing%20data%20and%20deleted%20and%20re-added%20the%20slicers%20but%20neither%20of%20these%20worked.%20When%20I%20first%20created%20the%20dashboard%20everything%20worked%20and%20I've%20not%20changed%20anything%20so%20would%20assume%20it%20should%20still%20be%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3527859%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3530264%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20not%20updating%20when%20source%20data%20is%20updated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3530264%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1256486%22%20target%3D%22_blank%22%3E%40Amanda2503%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EYou%20need%20to%20clean%20PivotTable%20cache.%20Right%20click%20on%20it%2C%20PivotTable%20options%2C%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20718px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20718px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F382112i65B03DDEF1E08A19%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Echange%20%22Number%20of%20items...%22%20from%20Automatic%20on%20None%2C%20Ok%20and%20refresh.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOr%20add%20data%20to%20data%20model%20creating%20PivotTable%20and%20build%20it%20on%20data%20model.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

 

I have a dashboard showing project data with multiple pivot tables. There are two slicers that are connected to all the pivot tables, Project ID and Project Status, these used to update when the source data changed but this is no longer the case and still doesn't update after refreshing the data. E.g. The Project Status of Project LIB682 changed from Active to Closed in the source data, however, if I select 'Active' in the Project Status slicer, LIB682 still appears in the ID slicer where it used to be greyed out to show it is not active. 

 

I have tried refreshing data and deleted and re-added the slicers but neither of these worked. When I first created the dashboard everything worked and I've not changed anything so would assume it should still be working.

 

TIA

1 Reply

@Amanda2503 
You need to clean PivotTable cache. Right click on it, PivotTable options, here

image.png

change "Number of items..." from Automatic on None, Ok and refresh.

 

Or add data to data model creating PivotTable and build it on data model.