Creating Trend graphs for Weekly Data

Hi Anonymous,

You can check the following steps if they suitable for your requirements.

Steps:

1. Create a expand table based on id and its date ranges.

Expand = 
SELECTCOLUMNS (
    FILTER (
        CROSSJOIN (
            Test,
            CALENDAR ( MIN ( Test[Creation Date] ), MAX ( Test[Last Modified] ) )
        ),
        [Date] >= [Creation Date]
            && [Date] <= [Last Modified]
    ),
    "ID", [ID],
    "Date", [Date]
)

2. Build a relationship from expand table to original table based on id field with 'both' direction mode.

3. Create a line chart with expand table date as axis, original table 'status' as legend and 'id' as value. (If you need a trend line, you can enable it in the analysis panel trend option.)

4. Create a slicer with status fields to choose display records.

Snapshot:

BTW, I also attached the sample file below.

Regards,

Xiaoxin Sheng