One line chart for different calculations

[miii]

Hi - 

I'm looking for a dax measure for a line chart graph to combine multiple values into one line. Currently it's showing each line for one calculation and when a specific month is selected it truns into a dot for that month, but instead I'd like to display a line for previous months and continuation of the same line to reflect forecast.

[v-lili6-msft]

hi, @miii 

Do you mean that when you select one specific month, there are still previous month and next month data in the chart? IF so, you don't need to select any month. When you select one month, other month will be filtered in the visual.

If not your case, please share your sample pbix file and expected output not just the formula of measure.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Lin

[Greg_Deckler]

Can you provide an example of data and your current calculation? How are you doing the forecasting?

[miii]

Thanks for help Greg - This is the code being used for calculations

Indirect Labor Budget YTD:=
CALCULATE(
	[Indirect Labor Budget],
	DATESYTD('Calendar'[Date])
)

Indirect Labor Forecast YTD:=
CALCULATE(
	[Indirect Labor Forecast],
	DATESYTD('Calendar'[Date])
)

Indirect Labor Actual YTD:=
var maxyear = MAX('Calendar'[Relative Year Index])
var _month = MAX(Scenario[SCENARIO_NUM])
return
calculate(
CALCULATE(
[Indirect Labor Actual],
filter(
'Calendar',
and(
'Calendar'[Relative Year Index] = maxyear , 
'Calendar'[Month] <= _month
)
)
), 
DATESYTD('Calendar'[Date])
)