DAXian's avatar
DAXian
Frequent Visitor
1 year ago
Status:
New

Update Forecast options to work dynamically when expanded or drilled up.

I love how during initial drafts I can easily create a forecast thanks to line chart's Forecast option. The issue is if I have created a monthly level forecast for example for the next 12 months : 

I hope that if I select Units as Months, on a month-level date hierarchy, if I drill up to quarter it will still work for 4 quarters if the unit for seasonality is month as well. Or if I drill up one more to Year, it will still produce a forecast for 1 year because of the 12 months Forecast Length and 12 months Seasonality (not 12 points seasonality). This small fix will make the forecasting work drilling up or expanding down. Also, say if I am on a Year level with 1 Year forecast length, and 1 year seasonality, it will also work as i drill down because both 1 year is automaticall working as 4 quarters in a year, 12 months in a year, 365 days in a year the more I drill down on my line chart. Hope this get's noticed!

If the forecast has a downward projection, I can easily decide and create a solution to produce the forecast values to a table using a matrix. But if it is going up, say I do not need to create a detailed forecast. I can easily use the built-in one.

No CommentsBe the first to comment

Recent ideas