Hi I'm having an issue where the lines representing the months on a chart axis shows the beginning of the month, but the data points on the series line are located at the end of the month.
The left shows chart grid lines for months Jul 19, Sep 19 and Nov 19.
The data point for value '90' is for the month of Nov (I checked, that the value '1' is for month of Jul etc), though the date shows as 1/11/19. Is there a way to align the data point to the relevant month's grid line, to make the chart clearer and less confusing? Since the data points don't match up locationwise with the chart axis grid for the months, its confusing for the dashboard viewers to see which data points represent which month. It would also be helpful to be able to customise the hover labels to only show '11/2019: 90'
The chart parsing pattern is set as below.
Any other parsing pattern options result in this
Any advice would be appreciated, thanks!