Forum Discussion
Slicer not updating when source data is updated
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
I am using latest version of Office 365. My issue is the following:
I update data using Power Query.
When I go to a pivot table with slicers, I have to select at least one of the slicers before the pivot table updates. This is very confusing for example if I have Region A and Region B in a slicer and Region A is selected before updating and I then refresh all data, it still shows the old data for Region A when I go to the sheet. The data actually only update in the table if I select either Region B or Region A again. This is very confusing for users.
Amanda2503
You need to clean PivotTable cache. Right click on it, PivotTable options, herechange "Number of items..." from Automatic on None, Ok and refresh.
Or add data to data model creating PivotTable and build it on data model.
SergeiBaklan Hi. I am having a similar issue with Slicer not updating when source data is updated in the query, specifically I added a new file w/ data to the query aggregator. I tried your suggestion below w/o success. I see the new data in the pivot table / query (from the newly added file) but not in the slicers. If I create a entirely new pivot from the updated query tab then the slicers are updating correctly, however I do not want to recreate my pivot tables. thanks
post note.. now if I filter the new data in the pivot directly then I see the data in the respective slicer but it is "grayed out" as if there is no data. I can select the gray out slicer category to filter the pivot table. Question: How do I get the slicer to format the category to be the same "blue" as the other slicer categories (e.g. have data.) Otherwise this will be confusing to the user.. categories with data vs no data.
If I unclick "visually indicate items with no data" then the issue go aways, however this seems not logical.. what am I missing here?
- Thank you sir, it helped.
Thankyou, worked for me.
MilroV2 , you are welcome
