Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Patron
Post Patron

How to forecast sales with Power BI

Power BI community,


I am wondering how to create sales forecast dashboard with Power BI.

I know it is capable of it, but not sure how to achieve this.


I want to show the final output to be in a monthly calendar format as below.


2018-01-30 15_08_22-A&P Master Dashboard_v2 - Power BI.png


First off, I have 3 different dataset.

  1. Actual figures (Historical Data)
  2. Current month data
  3. Year to go data


If the current month is July, then 1 would be Jan-June, 2 would be July and 3 would be Aug-Dec.


Please find below as the Power BI with sample data loaded in.

Sample Data


Here is what I would like to do.

  1. Using historical/actual data, I would like to forecast the volume for all the months in 3. Year to go data. (In the data I loaded, I have dummy volume numbers, but would be nice to forecast volume using 12 months seasonality)
    • Using Historical dataset in Sample Data.pbix, I would like Power BI to forecast the volume in Aug-Dec'18
  2. With the volume forecasted in number 1, I would like Power BI to calculate Gross Sales to Net Net Sales. (If you can show me a way to calculate First Commissions for example, then I will do the same process for the rest of the categories)
    • With the volume forecasted in 1, would like Power BI to forecast First Commissions. I will do the same for the rest of categories such as Second commissions.
  3. In current month, I have a data from Gross Sales to Invoiced Sales for all the days. With the trend in the month, I would like Power BI to calculate the volume to be achieved by the end of the month along with Gross Sales
    • With Current Month dataset in Sample Data.pbix, I would like Power BI to forecast the volume and Gross Sales to be achieved in the month. 
  4. With all the data forecasted from step 1-3 above, I would like to put all of them together in a calendar view as the screenshot above.

I understand that there are a lot of questions, but once someone can teach me how to do forecasting in Power BI,

I should be able to figure out the rest, maybe.


Appreciate your support in advance.


Many thanks,





Memorable Member
Memorable Member

Memorable Member
Memorable Member

Powerbi can do forecast graphs but not provide the numbers.


R maybe a better as it has very powerful features and could provide a data set of forecasts.

Here are a couple of links that may get you started.


Hope this helps




Let me try and get back to you!


Many thanks,



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors