Forum Discussion

sundials's avatar
sundials
Regular Visitor
8 months ago
Solved

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 ar...
"CHART"
"DAX"
"DISCONNECTED TABLE"
"GRAPH"
  • vivien57's avatar
    vivien57
    8 months ago

    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

vivien57's avatar
vivien57
Super User
8 months ago

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