Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
You need to use a technique called burn down chart instead, which is a graphical representation of work left to-do versus time.
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.
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.
Any support dears...
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |