Creating Historical Graph with daily updated Excel data

[djohanlon]

Hi - I have an Excel spreadsheet which is sent to me everyday whih contains a lot of data (....). Aomgst this data, I do a calculation on (as an example) the amount of packages that have still not arrived at destination, which gives me an outstanding package number.

When I get the data flow the next day, that number has ususally changed - up for down.

What I need to do is track that variation from day to day. Preferably in a grpah format - sort of like you would see a stock ticker plotting the ups and downs of the stock.

How do I set up a graph so that I can do this?

Thanks

Daniel

[V-pazhen-msft]

@djohanlon 

Unfortunately, I am afraid this cannot be achieve, you can update the new excel to power bi using refresh with folder connector. But power bi is not a automate product that can create new graphs for the daily new files or even compare it with earlier excel files. And I cannot think of any workaround with power bi.

Paul Zheng _ Community Support Team