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 capture the total inventory value on daily basis in powerbi and then I can report a trend line on Total Inventory Value on Weekly, Monthly , yearly etc.

 

Any suggestions will be great.

 

 

Need Help

9 Replies

  • 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?