Chart smoothing help with low input weekends

[Anonymous]

Here is a sample of the data I am working with. The column with "Missing" can also be "On Time", "Late", or "Early".

The issue I am having is there are much fewer data points on the weekends so the chart jolts down and is extremely hard to read trends. How can I go about "linking" Saturdays to Friday and Sundays to Monday? Any other suggestions? 

Thanks!

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could create a new date column to combine the dates.

New Date =
VAR a =
    WEEKDAY ( 'Table'[Date], 1 )
RETURN
    IF (
        a = 7,
        CALCULATE (
            FIRSTNONBLANK ( 'Table'[Date], 1 ),
            FILTER ( 'Table', 'Table'[Date] = EARLIER ( 'Table'[Date] ) - 1 )
        ),
        IF (
            a = 1,
            CALCULATE (
                FIRSTNONBLANK ( 'Table'[Date], 1 ),
                FILTER ( 'Table', 'Table'[Date] = EARLIER ( 'Table'[Date] ) + 1 )
            ),
            'Table'[Date]
        )
    )

[Anonymous]

That's perfect. Thank you!

[Anonymous]

I would probably just filter out weekend days.  That would it would go straight from Friday to Monday.

-Jared

[Anonymous]

That is my current solution but the data is important for final reporting numbers. I'd like to be able to include it on the graph totals but not as a seperate point on the line