Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Forecast line

Dear,

 

I'm making a power BI set where i upload every half hour new information via excel. In essence it's a view of the current/open orders. i work in an environment where we receive orders on the same day. 

 

Green = picked orders

Red = open orders 

Blue = forecast

 

i added a forecast line but only want it to show at the end of the day (18:00) and make it a liniar line from 08:00 till 18:00

 

 

Any help is very welcome!

Need Help
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , for that you have to create a measure with time filter

     

    example measure, assuming you have forecast measure

     

    calculate([forecast], filter(Table, Table[time] = time(18,0,0) ) )

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Dear amitchandak 

      First of all so many thanks for your help!

       

      I do not have the forecast as a measure but a a colomn from excel (where i made the calculations for the forecast). Is there any way to do it without having the forecast as meassure?