Problem with Lower Bound in the Forecase Line

[Aleiadeh]

Greetings,

Please I need a support to solve the following issue:

I have in my dashboard line chart showing the progress of the work in the project (the cumulative weekly progress), I have added forecast line to the chart for the next two months. But unfortunatly the lower bound is giving values under the last progress value which is not logic since the progress impossible to go back !

As per the below photo the Lower Bound must be 22.8% or above not less than this value since the chart is cumulative progress.

Any idea to solve this issue please ..

Actually I tried to solve it in a roundabout way, by changing the confidence band style from fill to line but still I have issue with Tooltips box since its mentioned the Lower Bound .. So, is there any idea to remove the lower bound from the tooltips box ?

Thanks in advance.

[khalidhawashin]

You need to use a technique called burn down chart instead, which is a graphical representation of work left to-do versus time.

[v-alq-msft]

Hi, @Aleiadeh 

A forecast line projects future data points based on the data plotted in the visual. Forecasting can only be applied to one series of data in a visual. There are four options to customize in calculating the forecast.

Forecat Length:

The length of time into the future for the forecast. The units and number of units into the future can both be customized.

Ignore Last:

This controls at what point the forecast should start. This can be useful if you do not want recent data points to be incorporated into the forecast calculation.

Confidence Interval:

The confidence interval displays the boundaries of certainty for the forecast. The higher the confidence interval, the wider the bars will be to capture the variance of the projection.

Seasonality:

The seasonality setting can help control the forecast for any cyclicity within the series. This could be useful for forecasting sales of winter equipment, which would presumably have higher sales in the winter months than summer months.

For further information, you may refer to the following documents.

Power BI – Analytics Pane 

Use the Analytics pane in Power BI Desktop 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Aleiadeh]

Any support dears...