Hide the last 90 days of rolling average 365 day win % on a line and stacked column chart?

[JRHans09]

How do I hide the last 90 days of the line on the chart below? The line represents the 365 day rolling average win % calculation.

Win % measure:

Win% for All Jobs during Period Selected := 
DIVIDE(
    [Total Jobs Won],
    [Total Jobs during the selected period],
    0
) 

Rolling 365 day average for Win % measure:

Win% Rolling 365 Days Avg := 
CALCULATE(
    [Win% for All Jobs during Period Selected],
    DATESINPERIOD(
        Dates[Date],
        LASTDATE( Dates[Date] ),
        -365,
        DAY
    )
)

The line on the graph below represents the 365 day rolling average. How do I adjust the measure above to hide the last 90 days of the line?

[TeigeGao · Accepted solution]

Hi @JRHans09 ,

In your scenario, you can add the IF() function to change the value of the last 90 days to blank(), then it will not display.

Best Regards,

Teige