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...
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

     

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

    Hi chintanp,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a help to the others.

     

    Best Regards!
    Dale