Re: Data series graph in Power bi

Luchy_688 · ‎11-03-2022

Is it possible to create a 3 series data line graph in Power-bi as we can do in Excel?

For example:

I want to graph "x-value 1" in the x-axis with "y value 1" as Series 1 in my visual;

another line with "x-value 2" in x-axis and "y-value 2 in y-axis, and same with the third line (series 3) which is made of "x-value 3" in x-axis and "y-value 3" in the y-axis?

The graph is excel will look like this

As far as I know, the line graph in Power bi will only allow 1 x-axis value that is shared with all y-axis values. Would it be possible to assign x-values to its respective y-values for each line?

Thanks in advance.

Luchy_688 · ‎11-09-2022

Thanks for the reply. Is this what you are looking for?

x-value 1 and y-value 1 make up series 1 in the line graph.

x-value 2 and y-value 2 make up series 2 and so forth.

The graph in Excel will look like

In Power BI the graph will display one model at a time. I have created a slicer for the user to choose the model they want to see.

Luchy_688 · ‎11-09-2022

Model Name	X-value 1	Y- value 1	X-value 2	Y- value 2	X-value 3	Y value 3
Model 1	0	0	0	0	0	0
Model 1	0.04	0.11	0.04	0.11	0.1	0.1
Model 1	0.12	0.25	0.11	0.28	0.2	0.2
Model 1	0.2	0.25	0.2	0.43	0.3	0.3
Model 1	0.3	0.45	0.3	0.56	0.4	0.4
Model 1	0.4	0.5	0.4	0.68	0.5	0.5
Model 1	0.51	0.55	0.51	0.8	0.6	0.6
Model 1	0.62	0.68	0.62	0.9	0.7	0.7
Model 1	0.73	0.85	0.73	0.91	0.8	0.8
Model 1	0.84	0.9	0.83	0.96	0.9	0.9
Model 1	0.94	0.99	0.94	0.99	1	1
Model 2	0	0	0	0	0	0
Model 2	0.0007	0	0.0005	0.0031	0.1	0.1
Model 2	0.0021	0	0.0016	0.0053	0.2	0.2
Model 2	0.0036	0	0.0028	0.0144	0.3	0.3
Model 2	0.0052	0	0.0044	0.0253	0.4	0.4
Model 2	0.0073	0.0172	0.0064	0.0434	0.5	0.5
Model 2	0.0105	0.0181	0.0095	0.0844	0.6	0.6
Model 2	0.0156	0.0879	0.0142	0.1229	0.7	0.7
Model 2	0.0246	0.109	0.0212	0.164	0.8	0.8
Model 2	0.0444	0.132	0.0451	0.2676	0.9	0.9
Model 2	0.2074	0.371	0.1991	0.5577	1	1