Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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 |
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-...