Forum Discussion

sclement's avatar
sclement
Regular Visitor
4 years ago

Help needed with Graph for forecasting

Hi All,   I am new to the powerbi graphs for forecasting and I am trying to build a sales data graph in powerbi with the below requirements:   1. the x axis with continous dates of a month 2. Sa...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, sclement 

 

Please try the following methods.

Measure:

Preyear = CALCULATE(SUM('Table'[Actual]),DATEADD('Table'[Date],-1,YEAR))
Current = 
IF(SELECTEDVALUE('Table'[Date])<TODAY(),SUM('Table'[Actual]),SUM('Table'[forecast]))

The X-axis can be set in this way to get a continuous date of one month.

Measure = IF(YEAR(SELECTEDVALUE('Table'[Date]))=YEAR(TODAY())&&MONTH(SELECTEDVALUE('Table'[Date]))=MONTH(TODAY()),1,0)

June 28 and onwards are shown as forecast values. A line cannot be split to show solid and dashed lines. Does this result match your expected output?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

sclement's avatar
sclement
Regular Visitor
4 years ago

Hi Charlote , v-zhangti 

 

Thank you for providing me the solution!

Unforuntely it doesn't help me much as my very first problem is obtaining the Forecasted MTD sales. I couldn't find any appropriate resources or community forum post that helps me in this direction to obtain Forecasted MTD sales per each day.

 

Any advise on this would be very much helpful for me.

 

Thank you!

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, sclement 

     

    By what logic do you want to get your sales forecast? Is there a relationship with the previous year's data?

     

    Best Regards