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

 

 

 

 

Any help is appreciated!

Need Help

4 Replies

  • 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