Plot two columns as line chart

[chintanp]

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 

[vanessafvg]

@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]

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

[chintanp]

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]

@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]

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]

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

[v-jiascu-msft]

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