Forum Discussion

callenbkd's avatar
callenbkd
Icon for Helper II rankHelper II
1 year ago
Solved

Line Chart with Two Lines and One only displaying data for Months selected

I'm trying to create a line chart that compares actuals to budget by month.    I want the actual months to only show the line for the months from 1 to the month selected whereas the budget data wou...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    callenbkd good solution from gmsamborn but to avoid flat line for actual, use following measure:

     

    Actual YTD = 
    CALCULATE(
        [Actual],
        DATESYTD ( 
            CALCULATETABLE ( VALUES ( 'Date'[Date] ),  'Date'[MonthNo] <= MAX( 'Month'[Month] ) ) 
         )
    )
callenbkd's avatar
callenbkd
Icon for Helper II rankHelper II
1 year ago

Thank you for your help. I didn't see the response until today. The misunderstanding here is it appears the amounts are based on the period selected. However, what the amounts should be are the YTD amounts. When changing the amounts to YTD amounts, the actual line displays for all periods. I want it to stop at the selected month.