Hello,
I'm trying to use actual sales during a pre-order moment to determine how many pieces per item should be ordered.
For this I use the forecast function in the Power BI line graph visual which works really great. The only thing is, I can only see the forecasted value while hovering over it with my mouse, which makes it difficult to determine an order amount for a lot of items (about 2000). Also I cant use these values in formulas.
My question is; is it possible to create (for example) a table which displays this forecast?
The eventual result I want to see is the forecasted sales on a date in the future for a specific item.
Here is a fictional simplified dataset that I'm trying to use. The real dataset will use about 2000 items with 98 days of sales and the to be forecasted amount of days is 168.
| Item | Quantity | Date |
| item 1 | 40 | 1-jul |
| item 1 | 55 | 2-jul |
| item 1 | 38 | 3-jul |
| item 1 | 59 | 4-jul |
| item 1 | 60 | 5-jul |
| item 1 | 59 | 6-jul |
| item 1 | 38 | 7-jul |
| item 1 | 59 | 8-jul |
| item 1 | 48 | 9-jul |
| item 1 | 58 | 10-jul |
| item 1 | 69 | 11-jul |
| item 1 | 48 | 12-jul |
| item 1 | 38 | 13-jul |
| item 1 | 32 | 14-jul |
| item 1 | 52 | 15-jul |
| item 1 | 62 | 17-jul |
| item 1 | 74 | 17-jul |
| item 1 | 43 | 18-jul |
| item 1 | 54 | 19-jul |
| item 1 | 34 | 20-jul |
| item 1 | 65 | 21-jul |
| item 1 | 37 | 22-jul |
| item 1 | 48 | 23-jul |
| item 1 | 61 | 24-jul |
| item 1 | 61 | 25-jul |
| item 1 | 48 | 26-jul |
| item 1 | 37 | 27-jul |
| item 1 | 71 | 28-jul |
| item 1 | 74 | 29-jul |
| item 1 | 82 | 1-aug |
| item 1 | 71 | 3-aug |
| item 1 | 61 | 7-aug |
| item 1 | 65 | 8-aug |
| item 1 | 36 | 10-aug |
| item 1 | 57 | 11-aug |
| item 1 | 86 | 12-aug |
| item 1 | 36 | 13-aug |
| item 1 | 26 | 14-aug |
| item 1 | 100 | 15-aug |
| item 2 | 3 | 1-jul |
| item 2 | 4 | 2-jul |
| item 2 | 5 | 3-jul |
| item 2 | 4 | 4-jul |
| item 2 | 5 | 5-jul |
| item 2 | 0 | 6-jul |
| item 2 | 0 | 7-jul |
| item 2 | 2 | 8-jul |
| item 2 | 0 | 9-jul |
| item 2 | 5 | 10-jul |
| item 2 | 6 | 11-jul |
| item 2 | 4 | 12-jul |
| item 2 | 0 | 13-jul |
| item 2 | 3 | 14-jul |
| item 2 | 2 | 15-jul |
| item 2 | 0 | 16-jul |
| item 2 | 3 | 17-jul |
| item 2 | 3 | 18-jul |
| item 2 | 2 | 19-jul |
| item 2 | 0 | 20-jul |
| item 2 | 4 | 21-jul |
| item 2 | 3 | 22-jul |
| item 2 | 5 | 23-jul |
| item 2 | 0 | 24-jul |
| item 2 | 0 | 25-jul |
| item 2 | 0 | 26-jul |
| item 2 | 6 | 27-jul |
| item 2 | 0 | 28-jul |
| item 2 | 0 | 29-jul |
| item 2 | 2 | 30-jul |
| item 2 | 0 | 31-jul |
| item 2 | 0 | 1-aug |
| item 2 | 0 | 2-aug |
| item 2 | 1 | 3-aug |
| item 2 | 0 | 4-aug |
| item 2 | 0 | 5-aug |
| item 2 | 0 | 6-aug |
| item 2 | 3 | 7-aug |
