I want to combine a stacked area chart where I show the accumulated pipeline of Sold, weighted and unweighed pipeline i relation to the salesplan. It is a very useful way to view the sales pipeline and easy to make in Excel (see picture). However, I am not able to generate this combined graph in Power BI. Any tips?
Was this ever solved?!? I don't think so because i'm running into the same issue 😞
To recap the problem - is there functionality in BI to create a combo chart with *stacked area* and *line*? Equivalent to the selecting in excel combo chart below.
NOT *stacked column* and *line*
NOT *area* and *line*
Appreciate help with this!!
We can achieve this by importing Power KPI chart from the market place without writing any code. Load Power KPI chart from app source(Market Place) to power BI desktop and create the chart as shown below.
Power KPI chart by default creates the chart as a line chart
We can change the line chart to a combined line and stacked area chart by going to Fomat->line->Type and change Type from "Line" to "Area" for the columns you wanted to show as the area.
Please find the below screenshot for your reference.
Please accept this as a solution If this helps you.
A stacked area chart can meet your requirement, please refer to: https://www.tutorialgateway.org/stacked-area-chart-in-power-bi/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but the stacked chart tutorial does not cover the combination of a stacked area and a seperate line in one chart as shown in my example
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
I solved it partly with Stacked column and line shart, but it is not visually very good compared to using Stacked Area Chart When accumulatingpipeline and plan (Line), the width of the columns make the harder to compare. It would be good if Power BI could support line and stacked area charts
This is more of a workaround, but I hope it helps.
I personally recommend creating the stacked area chart with your "actual" data first. Then, copy&paste it over itself, switch the type to line, and replace the "actual" fields with the "target" ones. You should see the stacked area chart as you need it, and have a line over it demonstrating where you are in relationship to your target. They should both update with a refresh.
An alternative way of visualizing this information is through the KPI visual. Here's a brief tutorial/introduction, in case you find it helpful: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
Let me know if that works for you! I recommend the copy&paste method because trying to get the visuals to be exactly the same size can become frustrating if you're doing it manually. Please note that this method will limit your hierarchy capabilities, so I recommend adding in slicers and other interactive filters/highlights so you know what data you're working with.
Thank you for the suggestion. I tried it and struggle to make it work for 2 reasons.
1. adding the two graphs (1 displaying the stacked Area + 1 displaying the lines of plan and last year revenue) means that the Y axis may be different for the two graphs stacked on top of each other. ( I need to have automatic scaling of the Y axis and I found no way of haveing a common denominator that ensures that the Y axis scale was identical for the two graphs.
2. Displying the Legend for both graphs without overlapping each other was not achivable for me
Tips is appreciated
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.