Forum Discussion

djohanlon's avatar
djohanlon
Frequent Visitor
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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