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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Forecasting with multiple Values

Hello!  I am trying to use the parameters and forecasting to get a revenue prediction for the future.... 

 

With that being said, I can never get the forecasting option to show up!  

 

My goals are (I just really need to complete one of them)

- is to have Jan2020 until March2021 revenue stay the same, and then the forecasted numbers are changing (April - December)

-  be able to use forecasting to see the next 8 months and everything changes.

 

Attached is a screenshot of what I have currently

Year-Month = FORMAT('public view_transactions'[date].[Date], "MMM-YYYY")

nattiej101_2-1618577186906.png

 

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1 REPLY 1
lbendlin
Super User
Super User

Your X axis needs to be of datetime type.

 

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Docs

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

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.