chart with start and end date

Hi jeffr,

You can try to use below formula to generate the detail date table, then build relationship between original table and new table. After these steps, you can use new date form new table as the axis and drag id to value field with summary mode count.

Original table:

Sample:

Detail = 
VAR temp =
    SELECTCOLUMNS (
        'Sample',
        "Index", [Index],
        "StartDate", [StartDate],
        "EndDate", [EndDate]
    )
VAR vCalendar =
    CALENDAR ( MINX ( temp, [StartDate] ), MAXX ( temp, [EndDate] ) )
RETURN
    SELECTCOLUMNS (
        FILTER (
            CROSSJOIN ( temp, vCalendar ),
            [StartDate] <= [Date]
                && [EndDate] >= [Date]
        ),
        "Index", [Index],
        "StartDate", [StartDate],
        "EndDate", [EndDate],
        "Detail", [Date]
    )

Expand tableRelationship

Create line chart with above columns:

Regards,

Xiaoxin Sheng