Hi Forum - This has me stuck and your amazing help is hugely appreciated !!!
I have attached an example PBIX file. There is no date table included as the client works on a strange Week System and they do not require any other time intelligence by month etc.
Requirement 1: (1st sheet in PBIX): Depending on which week is selected i wish to show:
a) A solid line showing the actual average price up to that week (and not beyond it)
b) A dotted line showing the budgeted average price after that week (and not before or including it)
Requirement 2: (2nd sheet in PBIX): Which ever week is selected the graph will show that week and all the weeks after it (but not before it)
Thanks again guys and i really appreciate the help
Example_BudgeT_by_Week.pbix (34.9 KB)