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

Need Help

2 Replies

  • 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