Forum Discussion
Fiscal year forecasting analytics
OK, here goes...
Have your Fiscal year column as whole number.
Select the column and in the Format window type in your FY format. In my case "FY"00 to get
Even though it looks like the column is now type text, it is actually still a whole number. You can now use the column in the axis and add the forecast :
Anonymous unfortunately not, not I'm aware and can think of.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
I don't have acces to Desktop, but won't including the date field and Fiscal Year on the axis work? And the drill down to FY?
The moment I add FY to the axis, the Forecast functionality gets disabled.
OK, here goes...
Have your Fiscal year column as whole number.
Select the column and in the Format window type in your FY format. In my case "FY"00 to get
Even though it looks like the column is now type text, it is actually still a whole number. You can now use the column in the axis and add the forecast :
Thanks, that seems to work.
Related to this, is Forecasting possible only for single series data? Our client got back asking if a Stacked Area chart could be shown with the forecasting data. Based on what I can see, it doesn't seem possible. Is Forecasting possible only in Line Graph?