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 w...
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.
Thankyou, worked for me.
MilroV2 , you are welcome