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

There is also a date table. They use a standard calendar year. The date table has a year colum and a month column, in addition to the date column.