Forecast line

[Vosjeee7502]

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!

[amitchandak]

@Vosjeee7502 , 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) ) )

[Vosjeee7502]

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?