Forum Discussion

Senz's avatar
Senz
Frequent Visitor
3 years ago

Forecasting in Power BI

Hello!

I am currently considering the utilization of the standard forecasting feature integrated in Power BI, which relies on a line chart with continuous data. In this regard, I would like to inquire whether it is possible to modify the predicted values generated by this feature?

To be specific, I am wondering whether it is possible to adjust the forecasted values through multiplication by a factor of, for instance, 0.8, thereby reducing these numbers. My intention is to allow users to manipulate input variables and subsequently modify the forecast based on certain assumptions.

Please note that I aim to maintain the historical data values as they are, with any modifications solely affecting the forecasted values generated by Power BI.

I apprecate your support!

 

Thank you.




Need Help

2 Replies

  • Adamboer's avatar
    Adamboer
    Responsive Resident
    3 years ago

    Yes, it is possible to modify the predicted values generated by the standard forecasting feature in Power BI. One way to do this is by creating a new measure that multiplies the forecasted values by the desired factor, such as 0.8, while leaving the historical values unchanged.

    To accomplish this, you can create a new measure in the same table as your forecasted values. For example, if your forecasted values are in a measure called "Forecast", you can create a new measure called "Adjusted Forecast" with the formula:

    Adjusted Forecast = Forecast * 0.8

    You can then add the "Adjusted Forecast" measure to your line chart and it will display the modified forecasted values based on the new measure. This way, users can adjust the forecast based on their assumptions without affecting the historical data values.

    • Senz's avatar
      Senz
      Frequent Visitor
      3 years ago

      Hi Adamboer, 

      thank you for your response on this. 
      I have a follow up question. You are mentioning that the a measure could be created "in the same table as your forecasted values". But from my understanding, these forecasted values are not stored in a certain table, but only displayed in the visual (line chart) itself. 

      I could extract and export the forecasted values into Excel  - this is the only way that I am aware of receiving these values into a table format?