Forum Discussion

Power-BI-GA's avatar
Power-BI-GA
New Member
3 years ago

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

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 v...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
3 years ago

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's avatar
Power-BI-GA
New Member
3 years ago

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