cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power-BI-GA
New Member

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 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 ExampleDataset Example

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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.

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.

 

Immagine1.png

 

Thanks,

 

GA

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.