topic Continue Line chart based on a value until 100% in DAX Commands and Tips

Continue Line chart based on a value until 100%

Anonymous — Wed, 24 Jul 2024 07:48:19 GMT

Hi,

I have the line chart below and we have data until 23 July but I want the graph to continue until 100% based on the previous speed of the graph.

It will be the prediction of when this will be finished. If you want to see what I mean in excel this is the chart in excel.

The blue line is the extension line.

We subtract %Completion of each day with the previous day and the average of all these days will be the average progress speed and I want to continue the line based on that number until it reaches 100%.

Is there a way that this can be acheived?

Re: Continue Line chart based on a value until 100%

Anonymous — Wed, 24 Jul 2024 08:09:58 GMT

Hi you need to align the actual and forecast line in a single line. its possible. I am sharing my youtube video link

https://www.youtube.com/watch?v=hNU6M1yjz80&t=11s
also you can refer my S-Curve Playlist for the same.

Re: Continue Line chart based on a value until 100%

Anonymous — Wed, 24 Jul 2024 08:21:39 GMT

Another way I have just figured out.
Source data

Monthly Progress

Cumulative Progress

Cumulative Actual Progress

Cumulative Forecst Progress

Overall Graph