Currently, the Forecast feature in Power BI Desktop only allows us to use the “Ignore last” option to exclude recent data points. While helpful, this approach is limited because it only removes a fixed number of periods at the end of the series.
I propose adding the ability to exclude data by specifying a custom date range - for example, “Ignore from 12 Jan 2023 to 14 Jun 2023.”
It would be much more flexible if we had the ability to specify a custom date range for the forecast input window - for example, selecting “From [date]” and “To [date]” boxes. This would allow users to:
Exclude incomplete or anomalous periods anywhere in the dataset, not just at the end.
Focus forecasts on stable historical windows (e.g., only 2019 - 2023 data).
Run comparative forecasts across different ranges without reshaping or filtering data outside Power BI.
This enhancement would make forecasting more accurate and user‑friendly, especially for organizations dealing with partial reporting periods or seasonal anomalies.
I’d love to see this added to Power BI Desktop to give us more control over forecasting scenarios.
