Help me create this graph
Hi, I'm trying to recreate this chart here. But I'm failing and only get this one: My summer hire column is found in my data table. I dragged it to my legends. Here's are my DAX formulas for more context: Retained 3M = VAR PeriodStart = MIN('Calendar'[Date]) VAR PeriodEnd = MAX('Calendar'[Date]) RETURN CALCULATE( COUNTROWS(Employment), Employment[Hire Date] >= PeriodStart && Employment[Hire Date] <= PeriodEnd, ( ISBLANK(Employment[Termination Date]) || Employment[Termination Date] >= EDATE(Employment[Hire Date], 3) ), CROSSFILTER('Calendar'[Date], Employment[Hire Date], None) ) Retention 3M = DIVIDE([Retained 3M], [Cohort Size], 0) Cohort Size = CALCULATE( COUNTROWS(Employment), Employment[Hire Date] >= MIN(Calendar[Date]) && Employment[Hire Date] <= MAX(Calendar[Date]) ) I created a disconnected table and create retention % as measure: Retention % = VAR SelectedPeriod = SELECTEDVALUE(RetentionAxis[Period]) RETURN SWITCH( SelectedPeriod, "3M", CALCULATE([Retention 3M]), "6M", CALCULATE([Retention 6M]), "12M", CALCULATE([Retention 12M]), "24M", CALCULATE([Retention 24M]), BLANK() ) RetentionAxis = DATATABLE( "Period", STRING, "Order", INTEGER, { {"3M", 1}, {"6M", 2}, {"12M", 3}, {"24M", 4} } ) Please help!
