I have created a Dashboard which is related to a number of Pivot Charts, I then added a Slicer to the Dashboard which had Years that I could choose and the charts on the Dashboard would change to whichever year I choose on the Slicer.

This worked fine until I need to add data to the current year 2023, when I inputted any changes to 2023 and then Refreshed the data what happened next was the Pivot table disappeared from the Dashboard.

Is this normal or is there a way round it, It may be that using a Slicer for this application is not the better option.

Any help would be appreciated.

Steve