Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now

Reply
Majidbhatti
Advocate IV
Advocate IV

Time Series forecasting data vs view

Hi

 

I am having 10 years of data on daily basis which means i have around 3650 points for the "Time series forecasting". When i put all 10 years of data on a line chart and then add the forecasting line via Analytics, i can see the near to accuate forecast line. But my problem is that the data range is huge with very wide chart where the chart points become very small and very difficult for user to focus. 

 

On the otherhand, when i add a year slicer for current year, the forecast is also changed.

 

What i need is that the forecast line pick all 10 years of data knowledge but on the chart it on show the current year, is this possible?

3 REPLIES 3
amitchandak
Super User
Super User

@Majidbhatti , Whatever data point you use based on that forecast will be calculated. You have to keep data at the date level to have a better forecast.

Just see if you can use Date Hierarchy to Control Display.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak my problem is not what it is showing on the x-axis. my problem is i only want to show the current year (as shown below), honestly user only wants to see 2020 data with forecasting based on 10 years of data. But when i select YEAR my whole forecast goes nuts (see below).

 

Annotation 2020-07-13 113101.png

 

Annotation 2020-07-13 113239.png

 

Hi @Majidbhatti ,

 

I‘m afraid it's unavailable,maybe you could adjust the point setting under "forecast" to make the showing more comfortable.

Annotation 2020-07-14 132419.png

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.