Line graph - Multiple lines return toward X axes

[siddbrk]

Dear,

I want to compare different charts with PowerBI.

Now Excel is used. There are a lot of CSV files that contain data. The data is extracted from the desired files via script and then graphs are made in an overview in Excel to be able to compare them. The problem is that the desired files have to be sectioned and the data retrieved every time.

I would prefer to collect the data via power query. Then it is easy to manage via a Dashboard.

The problem is that the graph curves and tilts back toward the X axis. All this is plotted in a line graph then the points are connected from right to left. But it should be from bottom to top. On this forum I have already seen a solution with the Charticulator. This only works for one line. I would like multiple lines (6) on a graph.

I have tried with the table below. But on the Charticulator I only get one line and on the lingref the dots are not connected correctly.

Name	Date	Current	Voltage
Device 1	16/07/2021	5	44
Device 1	16/07/2021	10	45
Device 1	16/07/2021	20	50
Device 1	16/07/2021	40	51
Device 1	16/07/2021	80	53
Device 1	16/07/2021	160	51
Device 1	16/07/2021	320	47
Device 1	16/07/2021	640	44
Device 2	16/07/2021	5	46
Device 2	16/07/2021	10	49
Device 2	16/07/2021	20	50
Device 2	16/07/2021	40	51
Device 2	16/07/2021	80	54
Device 2	16/07/2021	160	52
Device 2	16/07/2021	320	49
Device 2	16/07/2021	640	45
Device 1	17/07/2021	5	31
Device 1	17/07/2021	10	35
Device 1	17/07/2021	20	39
Device 1	17/07/2021	40	40
Device 1	17/07/2021	80	44
Device 1	17/07/2021	160	42
Device 1	17/07/2021	320	40
Device 1	17/07/2021	640	38
Device 2	17/07/2021	5	35
Device 2	17/07/2021	10	39
Device 2	17/07/2021	20	45
Device 2	17/07/2021	40	44
Device 2	17/07/2021	80	45
Device 2	17/07/2021	160	38
Device 2	17/07/2021	320	35
Device 2	17/07/2021	640	30

Kind regard Koen

[v-stephen-msft]

Hi @siddbrk ,

Could you tell me if your problem has been solved?
If it is, kindly Accept the useful reply as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[lbendlin]

You could swap X and Y axes ? 🙂

What may actually work is if you break up your data at the point where it curves back, and use two separate lines, one for each segment. Make the segments the same color so the users don't notice. See attached.