Chart displaying a different number to actual number

[Anonymous]

I'm having an issue with my chart in the desktop file to the published website chart. All of the numbers are seven days out. It is a calculated field in the dataset of the desktop file. However, when I click on the slicer, it shows the correct number of days. I have attached some images to help show the differences.

When these numbers are displayed in a table, it shows the correct numbers.

Desktop FilePublished website chartPublished website chart with filter

[v-yulgu-msft]

Hi @Anonymous ,

Would you please provide some dummy data that can also reproduce this problem? How is the "Days FAI free" calculated? Please show its corresponding formula.

Best regards,

Yuliana Gu

[Anonymous]

HV Business PC	Date of Last LTI	Date of Last MTI	Date of Last FAI
NCCN	28/05/2016	01/04/2012	10/08/2018
Maitland	03/06/2013	10/04/2017	12/02/2019
Muswellbrook	01/06/2016	18/03/2019	16/07/2018
Gunnedah	01/03/2015	09/05/2018	02/07/2018
Dubbo	21/06/2017	17/01/2018	27/06/2018
Port Waratah	26/08/2016	13/04/2016	20/12/2018
Binnaway	17/02/2010	01/12/2014	17/12/2018
Scone	26/10/2016	08/03/2017	18/12/2016
Narrabri	15/01/2012	22/02/2017	01/10/2015
Structures	01/07/2011	24/08/2016	12/12/2016

and the calculated fields for the chart are 

Days FAI Free = datediff('Injury Free Days'[Date of Last FAI], TODAY(), DAY)

I have found that the chart works if I include all of the [HV Business PC], but if I filter out the "Structures" HV Business PC at the page level so it doesn't show in the slicer or chart then the problem of the seven days difference occurs.

Thanks.