Forum Discussion

nn92's avatar
nn92
Frequent Visitor
8 years ago

Plotting two areas in one graph

Hi guys, I want to show those two graphs on one in Power BI. The problem is that I can't put them on top of each other. I can do it in excel easily, but here I have problems. Pictures and data are...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi nn92,

 

Based on my test, you can refer to below steps:


1.You can choose the Stacked area chart visual. Put your "ATOT_LEADTIME_GRP" field into the Axis bucket and put your "EGLL" and "EDDF" fields into the Value bucket.

 

 

2.Finally you can see the result. You can also adjust the orders of the "EGLL" and "EDDF" in the Value bucket to decide which one can on the top of the other.

 

 

You can also download the PBIX file to have a view.

 

Reference:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-basic-area-chart

 

Best Regards,
Qiuyun Yu

nn92's avatar
nn92
Frequent Visitor
8 years ago

Hi,

 

Thanks a lot for the answer!

I could display it like that, but the problem is to put it on the same scale. Maximum value is 1 for me, and stacked chart displays one on top of each other, when I select the option to see one over each other I can get only one of the two parameters (one is displayed normally, and another as average value(tried to change it but unsuccesfully...))....

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi nn92,

     

    Based on my research, these two area section are stacked without overlapping. For your requirement, you can submit a idea.

     

    Best Regards,
    Qiuyun Yu 

    • prateekraina's avatar
      prateekraina
      Memorable Member
      8 years ago

      nn92,

       

      If same scale is the problem for you, then you can control minimum and maximum scale for Y Axis.

       

      Refer below screenshot:

       

      Prateek Raina