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

Here you go. This is sample data I created. 

 

ScenarioDateAmount
Budget1/1/20251000
Budget2/1/20251200
Budget3/1/20251300
Budget4/1/20251400
Budget5/1/20251500
Budget6/1/20251640
Budget7/1/20251760
Budget8/1/20251880
Budget9/1/20252000
Budget########2120
Budget########2240
Budget########2360
Actual1/1/2025900
Actual2/1/20251250