I am having trouble with the "Filter data independently for each Pivot Table report" function. Despite creating multiple dashboards, I am currently facing difficulties filtering my Pivot Table reports independently, particularly when they are linked to a Slicer. I have removed the Pivot Report connections to the Slicer.
I am also struggling to create a pivot for the "Date Verified" column, should be Month and Year.
The formatting of the Data Labels in the Pivot Chart also keeps on auto changing.
Could you please help me resolve these issues? Is this an Excel software issue? As I cannot find the option to change the filters to be filtered independently?
Thank you in advance for your assistance in advance.