Date Display Problem

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

I have tow columns dates and an associated number as follows:

12/28/2014 50.3
01/03/2015 42.2
01/10/2015 35.8

I aggregate on the date and show a chart with the date as the bottom axis (y) label and the number as the (x) axis. However, all dates are shifting to the previous week on the axis label. For example:

12/28/2014 displays as 12/21/2014
01/03/2015 displays as 12/28/2014

and so on. Any thoughts?

2

Fixed it. It was an issue with the way the BCS was configured for the date fields. It caused weird issues with the Plumsail app. See below for solution.

debugmonitor.wordpress.com/2015 … date-time/