Plot data wrt different x-columns in the same line chart

[Power-BI-GA]

Dear All,

I've a dataset as in the attached image with a simple table showing two temperatures data in column "C" and "E". I woould simply plot temp1 vs angle 1 (so column "C" vs "B") and temp2 vs angle 2 (so column "E" vs "D") in order to obtain a similar graph in Power BI.

Any help would be appreciated.

Thanks for your time,

GA

Dataset Example

[v-henryk-mstf]

Hi @Power-BI-GA ,

You can use the UNION & ROW Function to build a new table and then use the line chart to create this visual.

Creating Power BI Tables By Using UNION & ROW Function | Enterprise DNA

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Power-BI-GA]

Dear @v-henryk-mstf 

thanks for answering.

Onestly, however, I didn't understand how to solve my problem with the UNION & ROW function.

There is no error in this case, I'm not able to generate the line chart showed in my last comment inside PowerBI.

Is it possible to force the x-column wrt plot data in a line chart? In the following image for example, I could solve my problem telling to Power BI: plot Data 1 and Data 2 wrt x-axis column 1 (green lines); plot Data 3 wrt x-axis column 2 (red line). But it doesn't work.

Thanks,

GA