Forum Discussion
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
Microsoft Employee
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
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,
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
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