Forum Discussion

asodhani's avatar
asodhani
Frequent Visitor
8 years ago

how to do trend based on live data

Dear All,   I have live data coming from ERP system into PowerBi. It shows me on daily basis e.g. what is the count of Total Value of Inventory on real time basis. How is it possible for me to capt...
Need Help
prihana's avatar
prihana
Icon for Helper V rankHelper V
8 years ago

If you can get the data in below format

 

You can create below trend graph

 

asodhani's avatar
asodhani
Frequent Visitor
8 years ago

prihana

 

Thank you for showing me this.

 

The challenge is to get data in that format.

 

As I mentioned I have live data on my Dashboard. The data that was yesterday is already gone and not recorded anywhere. I am unsure on how to record that in powerbi somehow.

 

E.g. Today's data says $10. Yesterday it was $15. I cant see the value $15 anymore as the data refreshes overnight.

 

Is there a way where I can record $15 from yesterday somewhhere in the data table so that I can then start making reports / charts.

 

Cheers

 

Abhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi asodhani

     

    I'm experiencing the same problem. I want to show a trend of the live data, but the live data keeps on changing daily.

     

    Have you found a way of doing it? I need help to do this.

     

    My situation: I have live data of open tickets for my team. Everyday, the amount of open tickets keeps changing but my manager wants to see a trend of how many open tickets there are each day. But the data is live, and there is no time stamp. 

  • prihana's avatar
    prihana
    Icon for Helper V rankHelper V
    8 years ago

    asodhani

     I dont think it is possible wthin Power BI. You have to store the data in a DB or a text files (from the live source with a timestamp) and them iport it into Power BI