Forum Discussion
Amanda2503
Jun 20, 2022Copper Contributor
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 w...
SergeiBaklan
Jun 20, 2022MVP
Amanda2503
You need to clean PivotTable cache. Right click on it, PivotTable options, here
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.
UmairSiddiqui
Sep 08, 2023Copper Contributor
Thank you sir, it helped.