Forum Discussion
Data series graph in Power bi
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.
3 Replies
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216Model 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 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.
