Rolling Average visualisation issue Column Chart

Hi I noticed difference which i have to avoid somehow. It is between the table and the graph visualisation of data. 

Please take a look at my data model: 

https://docs.google.com/spreadsheets/d/1naChcuZtjSbk0pVEi1xKuTZhSY7Rpabc0OCbmxowQME/edit?usp=sharing

To calculate my Product 3Mth Average I am using the dax below

Product 3 Mth AVG = CALCULATE(SUM('Table'[Product A  uncum]);DATESINPERIOD('Table'[Date];LASTDATE('Table'[Date]);-3;MONTH))/3

It is showing the right numbers when i will place it in the table. 

BUT

When I am placing it on the graph it is showing it in this way

How Can I change the formula to present it in the right way. Now it is taking the difference between current month and previous one and divide by 3 which is not what i wanted to do.  Please help

Hi Anonymous,

I'd like to suggest you use below measure formula if it suitable for your requirement:

Product3Mth =
VAR currDate =
    MAX ( 'Table'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Product A uncum] );
        FILTER (
            ALLSELECTED ( 'Table' );
            'Table'[Date]
                >= DATE ( YEAR ( currDate ); MONTH ( currDate ) - 3; DAY ( currDate ) )
                && 'Table'[Date] <= currDate
        )
    )
        / 3

Regards,

Xiaoxin Sheng