Forum Discussion

chintanp's avatar
chintanp
New Member
9 years ago

Plot two columns as line chart

I have some battery cycling data. Of interest is the current and voltage value wrt time. These are three separate columns in my table. I want to plot Current vs Time and Voltage vs Time. 

 

I tried the "Scatter Chart" option and "Line Chart" option, however, it shows me the "Count of Current" instead of "Current". I tried adding the "Current" and "Time" to "Axis" and "Value" tabs without success.

 

This used to be very simple in Excel. The reason I am using Power BI is because I have many rows (millions).

 

Thanks 

Chintan Pathak 

 

 

 

7 Replies

  • chintanp's avatar
    chintanp
    New Member
    9 years ago

    I have some battery cycling data. Of interest is the current and voltage value wrt time. These are three separate columns in my table. I want to plot Current vs Time and Voltage vs Time. 

     

    I tried the "Scatter Chart" option and "Line Chart" option, however, it shows me the "Count of Current" instead of "Current". I tried adding the "Current" and "Time" to "Axis" and "Value" tabs without success.

     

    This used to be very simple in Excel. The reason I am using Power BI is because I have many rows (millions).

     

    Thanks 

    Chintan Pathak 

     

     

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      9 years ago

      chintanp

       

      Hi Chintan Pathak,

       

      Would you like it as the picture showed? You can use "Sum" if there is no duplicates in "Time".

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Best Regards!

      Dale

       

       

      • chintanp's avatar
        chintanp
        New Member
        9 years ago

        Nope, not 50 or 100 or Sum() on the Y-axis. I need the voltage value, i.e "somewhere between 2.5 volts" and keeps repeating, so like a periodic process. 

         

        I don't think I can explain it any better. Maybe Power Bi is not a tool for scientific research. 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    chintanp is it possible to share what your data  looks like?

     

    and what you expect it to be, ie. show a screenshot of excel

     

    so what you saying is you dont want current to be aggregated and you want to view it with a date?

     

    do you have a date table?

    secondly when you say its not working, what exactly is the problem?  a screenshot to get a better understand will help here

     

     

     

    • chintanp's avatar
      chintanp
      New Member
      9 years ago

      vanessafvg : Thank you for your reply. 

       

      My data looks like this: 

       

      Fields, test time (sec), current, voltage have been converted to "Decimal number" in Power BI. 

       

      The graph that I want to see is simply: 

       

       

      The X-axis has the test-time (sec) and Y-axis has Voltage, both are indivuidual values in separated columns in the same table.