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

Hi, Your problem is not clear. 

 

Do you want to show the chart on real time - as in a live chart that changes every minute

 

Or just a line chart that update on a daily basis 

asodhani's avatar
asodhani
Frequent Visitor
8 years ago

prihana

 

Sorry, I want to show the historical data.

E.g. Live data showed Inventoy Value $10 on 14 May

Live Data showed Inventory Value $15 on 15 May

Live Data showed Inventory Value $10 on 16 May

Live Data Showed Inventory value $10 on 17 May

 

I want the data to be captured so I can make a Trend line on Historical Data.

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

    If you can connect to the datasource from it is simple as creating a line chart and setting up a OnPrem gateway to update data on a regular basis.

     

    Whats the data source? Can you connect from Power BI Desktop? Do you have access to a Pro Licence?

    • asodhani's avatar
      asodhani
      Frequent Visitor
      8 years ago

      prihana

       

      Through Oracle.

       

      I think I am unable to explain clearly. As the live data yesterday is not same as today's live data, I am unable to make a trend line.

      • 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