Forum Discussion

Steffon's avatar
Steffon
Frequent Visitor
7 years ago
Solved

Need help-stacked line chart

Hello,

 

I am trying to create a line chart with the value on the Y-axis and the months on the X-axis.  Also, I have a category, customer, that I want to be represented as well.  

 

I am trying to create a line chart that has the total hours at the top and then it will shade in the hours for each customer on the inside.  I have attached an example for what I am trying to do. 

I like this graph below except I want the value of the customers to be split among that total:

If anyone can help I would greatly appreciate it.

  • Hi Steffon,

     

    Unfortunately, we can only display data labels on chart, legend names are not supported now.

     

    Regards,

    Yuliana Gu

4 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion

    if you have single KPI in the chart then you can add Customers as Legend - it will split the visual into stacked chart
    I don't know of a way of showing 2 KPIs on the same chart AND displaying separate series in PowerBI

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Steffon,

     

    How about placing [Custom] into legend of Stacked Area Chart?

     

    Best regards,

    Yuliana Gu

    • Steffon's avatar
      Steffon
      Frequent Visitor

      Hi,

       

      I got that to work but, what I am hoping is I can get the name in the shaded area. 

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        Hi Steffon,

         

        Unfortunately, we can only display data labels on chart, legend names are not supported now.

         

        Regards,

        Yuliana Gu