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...
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
    Icon for Microsoft Employee rankMicrosoft 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. 

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

        Hi chintanp,

         

        You have explained very clear. I found the difference of handling duplicates between Excel and Power BI. Excel keeps all the records. (at least in the line chart). While Power BI remove duplicates. I think you could try line chart in Power BI. 

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Best Regards!

        Dale