Stop a Power BI Forecast Line at a specific end date?

[AnonymousPerson]

Hello All...

I have a line graph in Power BI Desktop (shown below). I want to forecast daily YTD sales through the end of this year. 

The Forecast analysis tool built into the line graph only lets me specify a number of future periods. Well, this is always relative to what day of the year today is. I don't want to change it every day.

Is there a way to say that regardless of what day of the year today is, I only want to see a forecast through 12/31/2021?  Even with a 3rd party visual or a custom measure?

Putting a date filter on the visual doesn't work because the forecast time period parameters override that.

In the screen-shot, everything right of the vertical line should not be there.

Thanks!

[v-robertq-msft · Accepted solution]

Hi, @AnonymousPerson 

According to your requirement, I think that you can go to the X-axis of the line chart and set the end date manually as “2021-12-31”, like this:

Then the Forecast Line over '2021-12-31' will be hided in the line chart easily.

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[AnonymousPerson]

That works... Thanks!  I'll settle for updating the visual once per year, compared to once per day. 🙂

[AllisonKennedy]

@AnonymousPerson  Really good question, I'm posting here partly because I want to subscribe to other replies - there's possibly a custom visual that does this already. 

You could definitely achieve using a custom measure, but that would require you to do the forecasting formula manually and determine what type of regression analysis you want to use, takes the AI out of the visual. 

There are lots of different versions of this post in the Ideas forum - you can up vote it to see if it gets short listed: https://ideas.powerbi.com/ideas/idea/?ideaid=4b232cae-0823-4408-9a96-e42e124adcc4