Skip to main content

Power BI

New

Forecasting and Trend lines for custom date hierarchies/fiscal calendars

Vote (16) Share
Miles Cole's profile image

Miles Cole on 29 Mar 2018 00:16:25

Forecasting and trend lines DO NOT work if you are using your own custom fiscal calendar. MOST businesses have fiscal periods that don't align perfectly with calendar periods. If a custom date hierarchy is used, forecasting and trend lines should still work. It pretty ridiculous to have to tell executives that a trend line cannot be added to a visual.

Comments (2)
Miles Cole's profile image Profile Picture

cba02191 1e4e-4325-8596-52661bb156e7 on 06 Jul 2020 00:14:32

RE: Forecasting and Trend lines for custom date hierarchies/fiscal calendars

I would like to know if there is an update on being able to use a custom date hierarchy for forecasting. I agree it's pretty ridiculous to have to tell executives that a trend line cannot be added to a visual.

Miles Cole's profile image Profile Picture

81ce4dee 9a3a-4f38-98cd-2bc49c0c5fa2 on 05 Jul 2020 23:16:36

RE: Forecasting and Trend lines for custom date hierarchies/fiscal calendars

Interesting, I would like to understand a little bit more about how these trend lines are not working. I use custom date all the time and they work. Also when I make a linear regression measure I am pretty sure it matches the trend lines, however now I want to explore this a touch more if the value are identical.