Track weekly issues using a pivot - snapshots of data tables - power pivot?

Hi all,

I'm tracking issues raised on a weekly basis. This isn't a cumulative log, rather looking at issues for certain fields within a software system. This creates a snapshot and the purpose is to highlight the issues and remediate to zero findings.

Every week I have a different table of data which shows the issue number, which is then broken out by the user, region, country, and other fields and metadata.
I wanted to be able to track the progress, so each week plot the number of issues to see trends - easy at a high level perspective if I'm just looking at issues and volume over time, but I want to be able to see the progress selecting different fields. This is where I become stuck. I've looked power pivots, but I'm unable to work out that I need to do to be able to join the tables correctly. Essentially, if I had a time series plot, with some slicers, this would be the ideal scenario for me. Each week the I would want to add another table which would represent a weekly snapshot.

Attached is the initial tracker, I've removed a lot of the data as the issues would normally be around ~70k rows.

HELP!!!

I suggest you, kindly maintain data in one sheet & add column date.
Secondly in country list you mentioning lot of country name in single cell, its make sence. Plz enter single country name.
Then only by pivot you can track.
Ref attach file
For low impact 1 high for 2