Forum Discussion
Creating Historical Graph with daily updated Excel data
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
1 Reply
- AnonymousNot applicable
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