2 set of data on the same line chart

[fra37]

Hello,

I want to plot 2 sets of data with the same unit on the same line chart. I have the data of thousand of samples representing engineering strain-stress curves. I insert the engineering strain on the x-axis and the engineering-stress on the y-axis. I can sort them with the legend. I want to add samples data of the true strain-stress curve (for each sample both engineering and true strain, stress data is recorded). So I want to add the true strain on the x-axis and the true stress on the y-axis and then sort them with the legend (the same one than the previous curve). Then I can select if I want to visualize engineering, true or both strain-stress curves. 

Thank you for your help 🙂 

[fra37]

Hello,

Below you will find an example of the data I want to plot (just the first rows of my set of data). The idea is to plot the curve eng_strain/eng_stress and true_strain/true_stress on the same line chart. Then I would like to select if I want to plot only the eng_strain/eng_stress curve or true_strain/true_stress curve or both curves. 

Thank you for your help

eng_strain %	eng_stress MPa	true_strain %	true_stress MPa
0.000000000000e+00	4.424295727524e-01	0.000000000000e+00	4.424295727524e-01
1.334538683295e-03	1.769997057940e+00	1.334529778407e-05	1.770020679235e+00
2.624317130540e-03	2.804139697361e+00	2.624282695940e-05	2.804213286879e+00
3.950298705604e-03	3.966277362542e+00	3.950220683368e-05	3.966434042345e+00
5.248628440313e-03	4.779653458260e+00	5.248490704630e-05	4.779904324511e+00
6.749650347047e-03	5.776553431058e+00	6.749422568388e-05	5.776943328216e+00
8.248628000729e-03	6.839822750431e+00	8.248287820116e-05	6.840386941966e+00
9.652302833274e-03	7.918038342289e+00	9.651837028498e-05	7.918802615328e+00
1.124794711359e-02	9.211522850078e+00	1.124731457944e-04	9.212558957296e+00
1.274998416193e-02	1.021925835787e+01	1.274917142052e-04	1.022056131169e+01
1.408556941897e-02	1.110667104813e+01	1.408457749579e-04	1.110823548599e+01
1.574862864800e-02	1.219544936037e+01	1.574738868166e-04	1.219736997640e+01
1.724965055473e-02	1.345511874510e+01	1.724816297358e-04	1.345743970607e+01
1.850825385191e-02	1.430318660816e+01	1.850654128591e-04	1.430583387825e+01
1.987465191633e-02	1.520594569901e+01	1.987267716903e-04	1.520896782779e+01
2.137430943549e-02	1.643852541956e+01	2.137202545543e-04	1.644203904085e+01
2.287396229804e-02	1.744896989376e+01	2.287134660614e-04	1.745296116456e+01
2.413841430098e-02	1.830958656757e+01	2.413550145449e-04	1.831400621143e+01
2.549895085394e-02	1.920438013314e+01	2.549570042402e-04	1.920927704859e+01
2.699863398448e-02	2.040174329024e+01	2.699499000916e-04	2.040725148224e+01
2.849828684703e-02	2.136342636891e+01	2.849422685660e-04	2.136951457943e+01
3.037362592295e-02	2.259465028351e+01	3.036901407103e-04	2.260151309806e+01
3.181490581483e-02	2.376366188484e+01	3.180984594684e-04	2.377122227149e+01
3.337396541610e-02	2.473337927114e+01	3.336839754703e-04	2.474163378058e+01

[lbendlin]

Your sample data is rather inconclusive The stress values are too similar.

[fra37]

Hello,

Yes, this is normal. There are the first points of the curve. The curves are confidential and I didn't want to send 2000 points. But the idea is to draw 2 curves on the same graph (x-axis strain, y-axis strain) and to be able to choose if I want to see one or both curves. Do you have a method for doing this?

[lbendlin]

What part of my proposal would need to be changed?

[fra37]

I don't want to have index in x-axis., I would like to have strain. I then I would like to have a slicer to be able to select which curve I want to plot (engineering strain-stress curve or true strain-stress curve). 

Thank you in advance for your help

Best regards

François

[lbendlin · Accepted solution]

like this?

[fra37]

Yes exactly. I have to create a category column with true and strain. That was my missing information! Thank you for you help 🙂 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...