Stacked area chart trendline

[AKSteffensen]

Hi,

I have data on the following form

Case key	Start Date	Case Type	Case Status
A-1	11-05-2019	A	Open
A-1	12-05-2019	A	Refining
A-1	13-05-2019	A	Closed
B-2	11-05-2019	B	Open
B-2	11-05-2019	B	In progress
B-2	12-05-2019	B	Developed
B-2	13-05-2019	B	Closed
...	...	...	...

and so on, and have used it to create a stacked bar graph that displays burn-up in a graph similar to the one below.

What I am currently missing however, is the red trendline based on the observations with [Case Status] = "Closed".  The trendline should be based on all of the currently available data and should aid in predicting the amount of closed cases at a specific date.

The stacked area chart visualization sadly does not currently have the option to add trendlines. Hence, I am looking for help/inspiration regarding how this could be done currently. It should preferably be done using a measure of some sort, as I would like to be able to filter on Case Status, Case Type etc.

Thank you in advance!

Best regards,

Andreas

[v-piga-msft · Accepted solution]

Hi @AKSteffensen ,

Yes, there is no trend line for us to add in stack area chart in power bi currently.

What about trying other chart which has the trend line in power bi?

In addition, you may try the Line and Stacked column chart, then you could create the measure for Closed red as the line.

Best  Regards,

Cherry

[AKSteffensen]

Hi @v-piga-msft 

Since I have already implemented the regression as a measure, the Line and Stacked column chart column chart actually works. It just does not look as nice, as I would have liked it to, since I wanted the stacked area chart and not stacked columns. 

Hoping for such functionality at some point.

Thank you!

Best regards,

Andreas