topic Re: Help me create this graph in DAX Commands and Tips

Help me create this graph

sundials — Thu, 11 Dec 2025 16:20:34 GMT

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!

Re: Help me create this graph

vivien57 — Thu, 11 Dec 2025 16:25:41 GMT

Hello

I think, the main problem stems from the fact that your axis (the disconnected RetentionAxis table) does not filter the Calendar table, whereas your Retained 3M / Cohort Size measures use MIN/MAX(Calendar[Date]). As a result, each point on the axis returns the same period (not linked to the 3M, 6M, 12M, 24M), which produces flat lines. Furthermore, if you want multiple lines (e.g. Summer vs Non-Summer), you must use the Legend with a single measure (your ‘switched’ measure), as a Line chart does not accept multiple measures when a Legend is filled.

Have a nice day,

Vivien

Re: Help me create this graph

Irwan — Thu, 11 Dec 2025 22:47:48 GMT

hello sundials

i might be misunderstood but seems what you are doing is different from what you are trying to recreate.

the desired visual has summer/non-summer legend but your two visuals dont use the same legend.

otherwise, try vivien57 's solution.

Thank you.

Re: Help me create this graph

d_m_LNK — Fri, 12 Dec 2025 15:27:12 GMT

I agree with Irwan -- the issue is that your Legend needs to the the Summer/non summer column, Y Axis - % retention, X-Axis - month retention.

Re: Help me create this graph

Anonymous — Mon, 15 Dec 2025 10:22:28 GMT

Hi sundials ,

I would take a moment to thank vivien57, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

Re: Help me create this graph

Anonymous — Mon, 22 Dec 2025 10:46:59 GMT

Hi sundials ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions