Line Chart for tracking Market Share

So there are no dates in the excel source spreadsheet, which is why I did not post them. The excel source spreadsheet only contains market share data. The reason for this is that there are hundreds to thousands of rows for each country, and it would not be feasible (at least not practical at this time) to have a separate column with a date updated everytime the corresponding cells for the market share calculation was updated in excel.

That all being said, there are dates in the x-axis shown in my power BI line chart screenshot. My idea was to refresh this file daily, in hopes of seeing the updated changes from excel, and tracking them over time. So to reference my previous example, if the market share was 73.3% for a country when I started tracking it on august 10th, and the market share dropped down to 61.1% on August 22nd, I would expect to see something like this:

I guess I can try to boil it down to:

• Is this graph above possible to recreate based on a Power BI dax formula and me refreshing the file daily to capture the current market share on that day from the source file, then track it as such in the picture above? Can it be done without actual dates in the Excel source file?
• If not, do I have to create a separate column in my excel spreadsheet with dates? And if so, what happens when I refresh the date? would it render the previous date useless and mess up the chart?