Forum Discussion

VamsiP123's avatar
VamsiP123
New Member
2 years ago

Line and Stacked area chart

Hello All,

Can anyone help me with creating combined line and stacked area chart. I came to know that there is no any default visual to accomplish this. Is there any alternate way to do this?

 

Thanks in advance!

Need Help
Tips and Tricks

6 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi VamsiP123 ,

     

    You can try to do this using the Area chart that allows to have values on secondary axis and also to change the background for each line individually.

     

    Can you share what is the expected outcome please.

    • VamsiP123's avatar
      VamsiP123
      New Member
      2 years ago

      Hello MFelix  Thank you for looking into this. I have tried this one but the value's are not stacking up. They are just showing like line chart with shaded on.

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        Hi VamsiP123 ,

        Be aware that you need to do different measures for the different levels to simulate the stack.

        Cat A = Cat A values

        Cat B = Cat B values + CAT A values

        and so on.

    • VamsiP123's avatar
      VamsiP123
      New Member
      2 years ago

      Hey KRISHP1234  Thank you for looking into this. Actually I have multiple values and require to stack them as area chart and have separate value to show as line which should'nt stack in earlier one.

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        Hi VamsiP123 ,

         

        I don't know how many staked values you want to have but you can create one cumulative measure for each of the cumulative values and use a standard area chart and then you can add the other measures and for those remove the shaded area:

         

        Top one is the stacked area chart bottom one is the area chart, yo also need to do a custom tooltip probably to have the values separated.

         

        Pbix file attach.