cancel
Showing results for 
Search instead for 
Did you mean: 

Chart displaying a different number to actual number

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 chart.PNGDesktop FileWebsite published chart.PNGPublished website chartWebsite published chart with filter.PNGPublished website chart with filter

Status: Needs Info
Comments
Community Support Team

Hi @AJS ,

 

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

Community Support Team
Status changed to: Needs Info
 
AJS Occasional Visitor
Occasional Visitor
HV Business PCDate of Last LTIDate of Last MTIDate of Last FAI
NCCN28/05/201601/04/201210/08/2018
Maitland03/06/201310/04/201712/02/2019
Muswellbrook01/06/201618/03/201916/07/2018
Gunnedah01/03/201509/05/201802/07/2018
Dubbo 21/06/201717/01/201827/06/2018
Port Waratah26/08/201613/04/201620/12/2018
Binnaway 17/02/201001/12/201417/12/2018
Scone 26/10/201608/03/201718/12/2016
Narrabri15/01/201222/02/201701/10/2015
Structures01/07/201124/08/201612/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.