Forum Discussion
Forecasting based on logic
Hi,
I the below simple dataset.
| Date | Workpacks left to complete | Hours left to complete |
| 01/01/2023 | 100 | 10 |
| 01/02/2023 | 90 | 9 |
This data is used to plot a simple bargraph which overtime should work its way down to 0 once all packs are complete.
I have another dataset which shows the current hours that can be completed each week.
| Achieveable hours per week |
| 4.5 |
At the end of my bar graph I would like a forecast that shows how long will take to complete all workpacks based upon the current achieveable hours per week.
For example, based on the last data entered in the example there are 9 hours left to complete. We can achieve 4.5 hours per week thefore the estimated completion date would be 2 weeks from 01/02/2022.
Is this possible within Power BI?
2 Replies
Anonymous , Are you looking for something like this
Label only at the end of the line? Yes. Check this out.
https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464
