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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
cbabel
Frequent Visitor

Forecast function is missing

I am trying to find the Forecast function in the line chart but i can't seem to find it. Anyone knows where or how I can have that option?

to provide some context I have this sample table that is extracted from a website and i have the "Report Year" having a active relationship with a Date Table. 

Plotting the line chart with the Date from Date table and the measure which is the sum of prevalence_rate but i still don't get the option

cbabel_1-1733819950960.png

 



cbabel_0-1733819850672.png

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @cbabel 

Based on testing, forecast is not available if you add a legend or x-axis is set to categorical. Your sreenshot shows you're using  a legend.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

2 REPLIES 2
danextian
Super User
Super User

Hi @cbabel 

Based on testing, forecast is not available if you add a legend or x-axis is set to categorical. Your sreenshot shows you're using  a legend.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hey @danextian ,

Thanks for spotting that. It works now!


Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.